Skip to content
Tutorials Center
My learning

Topics

Lesson 12 of 38 ยท Masters and Ledgers

Bill-by-Bill Debtors and Creditors

Track outstanding invoices in Tally Prime with bill-by-bill details: New Ref, Agst Ref, Advance and On Account, credit periods and receivable ageing.

A customer balance of 60,000 tells you little. Which invoices make it up? Which are overdue? Did the last payment settle bill 101 or bill 104? Bill-by-bill (bill-wise) tracking answers these questions. It is the feature that turns the Sundry Debtors and Sundry Creditors groups into a proper receivables and payables system, and it powers outstanding reports, ageing analysis and payment reminders.

Switching it on

Bill-wise tracking depends on two settings:

  1. In F11 (Features), under accounting, enable Maintain balances bill-by-bill (the exact wording may vary slightly).
  2. On each party's ledger, set Maintain balances bill-by-bill to Yes and, if you like, enter a default credit period (for example 30 days).

Ledgers under Sundry Debtors and Sundry Creditors normally have it on. Cash, expenses and sales ledgers do not need it.

The four methods of reference

When you select a bill-wise ledger in a voucher, Tally asks for a Type of Ref (method of adjustment):

Method Meaning Typical case
New Ref Creates a new bill with a name or number and an amount A sales or purchase invoice
Agst Ref Settles (fully or partly) an existing bill A receipt for invoice 101
Advance A payment received or made before an invoice exists A customer pays a deposit
On Account A balance with no specific bill A general payment that you do not allocate yet

For a sales invoice of 40,000 to Mehta Traders, Mehta's line uses New Ref with the bill name INV-101 and the credit period (for example 30 days), which sets the due date. When Mehta pays 25,000 later, the receipt voucher credits Mehta using Agst Ref, picks INV-101 from the list of pending bills, and enters 25,000. The bill's pending amount becomes 15,000.

flowchart LR
    S["Sales voucher<br/>New Ref INV-101 40,000"] --> P["Pending 40,000"]
    R["Receipt voucher<br/>Agst Ref INV-101 25,000"] --> Q["Pending 15,000"]
    P --> Q
    A["Advance<br/>Receipt before invoice"] -.-> B["Adjust later<br/>Agst Ref"]

A bill begins with New Ref; receipts settle it with Agst Ref. Advances wait for the bill they belong to.

Four ways to refer

New Ref Creates a bill.
Agst Ref Settles a bill.
Advance Money before the bill.
On Account No specific bill.
1 / 2

Credit periods and due dates

Each bill gets a due date: the bill date plus the credit period. If the ledger has a default credit period, Tally proposes it; you can override it per bill. Turning on "Check for credit days during voucher entry" makes Tally warn you if a sales voucher would take a customer beyond their credit limit or period. A credit limit on the ledger (an amount) does the same for the outstanding balance.

The Outstandings reports (receivables for debtors, payables for creditors) list pending bills with their due dates, the days overdue and the amounts. The Ageing view groups pending amounts into buckets such as 0-30, 31-60, 61-90 and over 90 days.

Opening bills

When you start with existing balances, a debtor's opening balance of 60,000 must be broken into bills. After you enter the opening balance, Tally opens the bill-wise details screen where you list each pending bill by name, date, credit period and amount; the bills must total the opening balance. This is how old receivables arrive in the new books.

Advance, On Account and adjustments

An Advance receipt creates a pending item that stands for money you hold for the customer. When you later issue the invoice, you adjust: in the sales voucher the invoice is a New Ref, and in the bill allocation you can set it off with the advance, or you record the advance as an Agst Ref in a journal. On Account is the same idea, with no bill name; reports show it as an unallocated balance that you should clear later.

If you receive money and do not know the bill, use On Account. If you know the bill, always use Agst Ref. Many teams end up with large On Account balances that nobody can explain at year end.

A stand-in: pending bills and settlements

This stand-in applies receipts to bills like Tally's Agst Ref method and shows the pending amount of each bill.

Python Bills, receipts and pending amounts (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

A stand-in: receivable ageing

Ageing reports bucket pending bills by how long they are overdue. This stand-in computes the buckets for a given date.

Python Ageing buckets (stand-in)

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Common mistakes

  • Receipts without references. The customer's total is right, but you cannot say which bills remain.
  • Bill names that do not match the invoice number. Use the real invoice number so everyone can find the bill.
  • Enabling bill-wise after months of entries. Existing balances would have no bills; convert them carefully.
  • Ignoring On Account balances. They hide unpaid bills and distort ageing.
  • Wrong credit period. The due dates and overdue reports will all be off.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which method creates a new bill?

    New Ref creates a bill; Agst Ref settles one.
  2. 2. A customer pays against invoice INV-101. Which method do you use in the receipt voucher?

    Agst Ref picks the pending bill and reduces its balance.
  3. 3. A customer sends money before any invoice exists. How do you record it?

    An advance records the money received and waits for the bill.
  4. 4. What does the due date of a bill come from?

    Credit period (default from the ledger, or entered per bill) is added to the bill date.

Summary

  • Bill-by-bill tracking is switched on in F11 and per party ledger.
  • New Ref creates a bill, Agst Ref settles one, Advance records money before the bill, On Account has no bill.
  • Credit periods set due dates; outstandings and ageing reports use them.
  • Opening balances for parties are entered as lists of pending bills.

Next: Opening Balances and the Trial Balance