Import Outstanding Bills from Excel or a Tally Bills Receivable Report

In short: In Trade Receivables click Import Bills (Excel/CSV), choose a .csv, .xlsx or .xls file (for example Tally's Bills Receivable report exported to Excel) or paste rows, check the matched columns and the rows that will be skipped, and click Import. Party Name and Pending Amount (or Bill Amount) are needed; importing the same file again updates bills instead of adding them twice.

A step-by-step guide for BookAICall, an AI voice agent platform that makes and answers phone calls for businesses in Hindi, English, Hinglish and other Indian languages. Updated .

Steps

  1. Open Trade Receivables and click Import Bills (Excel/CSV) at the top of the page.

  2. Starting a new sheet? Click Download Template: it has the columns Party Name, Phone, Bill No, Bill Date, Due Date, Bill Amount, Pending Amount, Credit Days, GSTIN and Contact Name. Otherwise use the report you already have, such as Bills Receivable exported from Tally to Excel.

  3. Click Choose File and pick the .csv, .xlsx or .xls file. Or open Or paste rows (CSV), paste the rows with their header line and click Read pasted rows.

  4. Check the preview: the row where the header was found, how many rows are ready, which of your columns fills which field, the columns not used, and every row that will be skipped with its reason.

  5. Tick This file is my complete list of pending bills only when the file holds every pending bill: imported bills missing from it are then closed as paid. Leave it unticked for a partial file.

  6. Click Import, the button that shows the number of rows ready. The result shows bills added or changed, unchanged, new parties and bills closed.

Columns it understands

  • Party: Party Name, Party's Name, Customer Name, Ledger Name, Debtor, Firm Name, Buyer or Particulars. This column is needed.
  • Amount: Pending Amount, Outstanding, Balance, Closing Balance or Amount Due; or Bill Amount, Invoice Amount or Amount when there is no pending column. One of them is needed.
  • Bill number: Bill No, Invoice No, Ref. No., Voucher No or Reference.
  • Dates: Bill Date, Invoice Date or Date; Due Date or Due on. Tally's Overdue by days also works: the due date is worked out from today.
  • Credit Days (or Credit Period, Payment Terms), Phone (or Mobile, WhatsApp), GSTIN, Contact Name (or Contact Person).
  • The header row is found by itself among the first 15 rows, so the title lines of a Tally export do not matter. A sheet with no header is read as Party Name, Phone, Bill No, Bill Date, Due Date, Pending Amount.

Dates, amounts and due dates

  • Dates day first: 15-10-2026, 15/10/26, 15-Oct-2026 or Excel's own dates.
  • Amounts as Indian sheets write them: 1,25,000 or 85000 Dr. A Cr amount or an amount in brackets is a credit or advance, not money due, so that row is skipped.
  • Rows with no party name are skipped; Total and Grand Total lines are ignored.
  • No due date: the bill date plus the party's credit days, or 30 days when the sheet has none.

Importing again never doubles bills

  • A bill is matched by its party and bill number. A row without a bill number gets a fixed reference made of its date and amount, so the same row matches next time.
  • Changed amounts are updated, and payments you already verified here but your books do not show yet stay deducted.
  • With This file is my complete list of pending bills ticked, bills from earlier sheet imports that are not in the new file close with the reason Not in latest sheet. Bills that came from Tally are not touched by a sheet import, and bills you closed yourself stay closed.

Phone numbers in the file

The first valid Indian mobile number in the Phone cell becomes the party's contact, and the AI calls and WhatsApps it. A cell with two numbers, such as 98xxx xxxxx / 91xxx xxxxx, gives the first. Parties without a mobile appear under Missing Phones on Parties & Invoices; add one there or use Auto-Match CRM.

What happens after the import

Every party's totals and ageing are worked out again. A party whose overdue total (bills past their due date plus the Grace Days in Trade Settings, not disputed) reaches the minimum you set gets a card in Reminder Due on the Recovery Board, and the AI calls it in the next calling window. Promises already made are checked against the new figures: a party whose pending amount dropped by what it promised has its promise marked Kept.

Example: A wholesaler without the Tally connector

Shree Balaji Traders, a hardware wholesaler in Ahmedabad, does not want software on the accounts PC. Every Monday the accountant exports Bills Receivable from Tally to Excel, with Party's Name, Ref. No., Date, Due on and Pending columns, and imports it. The preview shows Party's Name → party name, Ref. No. → bill ref and Due on → due date, with 3 rows skipped because they are advances (Cr). She ticks This file is my complete list of pending bills, because the export has every party. 28 bills paid during the week close as Not in latest sheet, 6 changed amounts update, and 4 new parties come in without mobiles, so she adds their numbers from Missing Phones.

Tips

  • Export the full Bills Receivable report each time and tick the complete-list box: paid bills then close by themselves.
  • Keep the party names the same as your Tally ledgers, so a later switch to the connector matches the same parties.
  • If many rows are skipped for dates, change the date column to DD-MM-YYYY in Excel and import again.

Frequently asked questions

Tally se outstanding Excel mein nikal kar kaise upload karein?

Export Bills Receivable to Excel from Tally, then in Trade Receivables click Import Bills (Excel/CSV), choose the file, check the preview and click Import.

Will importing the same file twice create duplicate bills?

No. Bills are matched by party and bill number (or by date and amount when there is no number), so a second import updates them.

Why were some rows skipped?

The preview lists each one with its reason: empty party name, no amount, a date that is not a date, or a credit balance (advance).

What does the complete-list tick box do?

It closes earlier imported bills that are not in this file, as paid. Use it only when the file has every pending bill.

My sheet has no due date column.

The due date becomes the bill date plus the credit days in the row (or 30 days). Or add an Overdue by days column.

Can I upload a Google Sheet?

Download it as .xlsx or .csv and import that, or copy the rows and paste them under Or paste rows (CSV).

Do I need both the connector and imports?

No. Use one: the Tally connector keeps bills in sync by itself; imports are for anyone who prefers to upload a file.

Questions this guide answers

  • How do I upload a party-wise outstanding list from Excel?
  • Can I import Tally's Bills Receivable report?
  • Will importing the same bills twice create duplicates?

Related guides

Start the free trial · Book a demo · All guides

BookAICall provides enterprise AI voice agents with real-time conversational capabilities.

Contact: [email protected] | +91-8502044044 | Mansarovar Jaipur Rajasthan