BillBuddy

Sales Upload Template

Fill from your billing software (Marg, Busy, Vyapar, etc.) and import into Tally

Debtor Sales (Credit)

Dr Debtor A/c → Cr Sales A/c

Party buys on credit.

Cash Sales

Dr Cash A/c → Cr Sales A/c

Immediate cash at counter.

Bank Sales (Direct)

Dr Bank A/c → Cr Sales A/c

Via UPI/NEFT/Card.

Or upload filled template:

Uploaded Sales Data Preview

Date	Bill No.	Type	Party Name	Taxable	GST%	Total

Template has 4 sheets: (1) Instructions — step-by-step guide, (2) Sales Entry — fill your data here, (3) Tally Import — auto-generated Tally voucher format, (4) GST Summary — rate-wise totals for GSTR-1. CGST/SGST auto-calculate. Party names must match Tally ledger names exactly.

Journal Entry Module

For expenses, service bills, party-wise purchases without detailed line items

Expense / Service Bills

Dr Expense A/c → Cr Cash/Bank

Rent, electricity, fees etc.

Party-wise Purchase

Dr Party A/c → Cr Purchase A/c

Only party ledger maintained.

GST Adjustments

Dr Input GST → Cr Party A/c

Input credit, TDS, adjustments.

GST Booking Mode

Choose how scanned bills should book GST in journal entries

Total Amount mode: Books full invoice amount as single entry. E.g. Dr Rent A/c 11,800 → Cr Party A/c 11,800 (GST included in total)

Upload expense bills / service invoices above, or manually add journal entries below. OCR will extract party name, amount, and generate Tally journal voucher.

Date	Debit Ledger (Dr)	Debit Amount	Credit Ledger (Cr)	Credit Amount	Narration	Action

Upload filled:

Cheque OCR → Payment Voucher

Upload cheque image to auto-extract party name, amount, date and generate Tally payment voucher

How It Works

1. Upload cheque image (front side)

2. OCR extracts: Payee, Amount, Date, Cheque no., Bank

3. Review and edit details

4. Export Tally Payment Voucher (Dr Party, Cr Bank)

Tally Accounting Entry

Payment Voucher:

Dr. Party / Creditor A/c ... Amount

Cr. Bank A/c ... Amount

Narration: Payment to [Party] by Cheque No. [XXX]

Upload cheque images above (drag & drop or click). OCR will extract cheque details automatically.

Extracted Cheque Details

Cheque No.	Date	Payee (Pay To)	Amount	Bank Name	Bank Ledger

Receipt — Bill-wise Debtor Clearing

Match bank receipts against outstanding debtor invoices for Tally bill-wise clearing

How Bill-wise Clearing Works

Tally needs to know which invoice(s) are being settled.

1. Enter receipt/bank credit details

2. Add outstanding invoices for debtor

3. Allocate against specific invoices

4. Export with bill references for Tally

Tally Accounting Entry

Receipt: Dr Bank A/c, Cr Debtor A/c

Bill Reference:

Against Ref: INV-001 = 50,000

Against Ref: INV-002 = 30,000

New Ref: ADV-001 = 20,000 (advance)

Add Receipt Details

DATE

DEBTOR NAME

AMOUNT RECEIVED

BANK LEDGER

MODE

REF / UTR NO.

OUTSTANDING INVOICES (Bill-wise Allocation)

Invoice No.	Invoice Date	Invoice Amount	Amount Allocated	Type	Action

Allocated: 0 / Received: 0

Saved Receipt Entries

Date	Debtor	Amount	Bank	Mode	Ref No.	Bill Refs	Action

Invoice Generator

TEMPLATE TYPE

RECEIPT/INVOICE NO.

Your Business Information

BUSINESS/ORG NAME

GSTIN/TAX ID

ADDRESS

Recipient Information

RECIPIENT NAME

EMAIL / CONTACT

ADDRESS

Items / Services

Description	Qty	Rate	Tax %	Amount
				₹0

Subtotal: ₹0

Tax: ₹0

Total: ₹0

INVOICE DATE

PAYMENT MODE

NOTES / TERMS

Bank Statement Processed

BANK ACCOUNT NAME (Tally Ledger)

STATEMENT PERIOD

COST CENTRE (for all)

How Bank Statement Import Works:

Step 1: Download the Excel file below — it has all extracted transactions.

Step 2: Fill in the yellow highlighted "Party Name" cells for transactions where the party is unknown.

Step 3: Verify / edit the "Tally Ledger" column. Ledgers matching your Tally Master are shown in green, new ledgers in orange.

Step 4: Click "Export Tally Vouchers CSV" to get the Tally-importable file.

Step 5: Click "Export New Ledger Masters" if there are any new parties not in Tally — import this first to create ledgers.

Date	Description	Party Name	Type	Debit	Credit	Tally Ledger	Status

Bank Reconciliation

Use our standard template — paste Tally data & Bank data, then reconcile instantly

Step 1: Download Template

Download our standard Excel template with 2 sheets — "Tally Data" and "Bank Data".

Step 2: Paste Your Data

Copy from Tally bank ledger & bank statement, paste into the template. Columns are fixed: Date, Particulars, Debit, Credit.

Step 3: Upload Template

Upload the filled template here. BillBuddy reads clean, structured data — no guessing.

Step 4: Auto-Match

AI matches by amount + date. Shows matched, Tally-only, Bank-only entries with BRS.

Download Blank Template

Has 2 sheets with fixed columns: Date | Particulars | Debit | Credit. Open in Excel, paste your data, save, and upload back.

How to get data from Tally:
Gateway → Display More Reports → Account Books → Ledger → Select your Bank A/c → Press Alt+E (Export) → Excel → Copy the Date, Particulars, Debit, Credit columns into "Tally Data" sheet.

How to get Bank Statement:
Download from net banking (Excel/CSV) → Copy Date, Narration, Withdrawal, Deposit columns into "Bank Data" sheet.

Upload Filled Template

Upload the template after pasting both Tally and Bank data

OR upload separately:

Tally:

Bank:

TALLY DATA PREVIEW (0 entries)

Date	Particulars	Debit	Credit

BANK DATA PREVIEW (0 entries)

Date	Particulars	Debit	Credit

Upload template or both files to begin

0

Matched Entries

0

In Tally, Not in Bank

0

In Bank, Not in Tally

0

Difference Amount

TALLY LEDGER				BANK STATEMENT
Date	Particulars	Debit	Credit	Date	Particulars	Debit	Credit

Bank Reconciliation Statement (BRS)

Balance as per Tally (Book):0.00

Add: Credit in Bank, not in Tally:0.00

Less: Debit in Bank, not in Tally:0.00

Add: Debit in Tally, not in Bank:0.00

Less: Credit in Tally, not in Bank:0.00

Balance as per Bank Statement:0.00

How to read this:

Tally-only = In books but not cleared by bank (cheques issued not presented, NEFT initiated not processed)

Bank-only = Bank processed but not in books (bank charges, auto-debits, interest credited, direct deposits)

Matched = Both Tally and Bank agree. Bank date shown for reference.

Account & Settings

—

Bills used: 0 / 0

Plan expires: —

Tally Ledger Master List

Upload your Tally ledger list (CSV/Excel) so BillBuddy can auto-match party names by voucher type (Purchase → Creditors, Sales → Debtors, Salary → Expenses, etc.).

How to export from Tally

TallyPrime: Gateway of Tally → Chart of Accounts → Ledgers → Alt+E (Export) → Format: Excel/CSV.

Tally.ERP 9: Gateway of Tally → Display → List of Accounts → Alt+E → Format: Excel/CSV.

Best format: CSV with columns Ledger Name, Group, Alias. Plain single-column lists also work.

📋

Bill Limit Reached

You've used all your bills for this month. Upgrade your plan to continue processing.

Current Plan

Trial

Request Upgrade

Drop your purchase invoices here

Recommended Page Limits for Best OCR Results

PDF Splitter Tool

Invoice Details

Sales Upload Template

Debtor Sales (Credit)

Cash Sales

Bank Sales (Direct)

Uploaded Sales Data Preview

Journal Entry Module

Expense / Service Bills

Party-wise Purchase

GST Adjustments

GST Booking Mode

Cheque OCR → Payment Voucher

How It Works

Tally Accounting Entry

Extracted Cheque Details

Receipt — Bill-wise Debtor Clearing

How Bill-wise Clearing Works

Tally Accounting Entry

Add Receipt Details

OUTSTANDING INVOICES (Bill-wise Allocation)

Saved Receipt Entries

Invoice Generator

Your Business Information

Recipient Information

Items / Services

Bank Statement Processed

How Bank Statement Import Works:

Bank Reconciliation

Step 1: Download Template

Step 2: Paste Your Data

Step 3: Upload Template

Step 4: Auto-Match

Download Blank Template

Upload Filled Template

TALLY DATA PREVIEW (0 entries)

BANK DATA PREVIEW (0 entries)

Bank Reconciliation Statement (BRS)

How to read this:

Account & Settings

Tally Ledger Master List

Bill Limit Reached