How to Import Receipt Vouchers from Excel to Tally Prime
How to Import Receipt Vouchers from Excel to Tally Prime
Receipt vouchers record payments received from customers. Learn the required PDF format columns, accounting rules, and how to automate imports.
Who is this for: Tally Setup Docs
In business accounting, receipt vouchers (`F6`) document all cash and bank inflows, primarily customer outstanding settlements, capital injections, or loan receipts. If your business receives hundreds of payments daily via multiple payment gateways or bank channels, entering each receipt manually in Tally Prime is a bottleneck. Bulk importing them from an Excel registry resolves this.
Required Excel Columns for Receipt Entries
To ensure Tally assigns the debit and credit legs of receipts correctly, structure your Excel template with these headers:
| Column Name | Format | Description | Example Value |
|---|---|---|---|
| Date | DD-MM-YYYY | Date the payment was received | 08-04-2026 |
| Receipt No | Alphanumeric | Unique receipt voucher number | REC/2026/0012 |
| Customer Name | Text | Exact customer ledger name in Tally | Acme Retailers |
| Amount Received | Decimal | Net amount received in bank/cash | 18500.00 |
| Bank / Cash Ledger | Text | Exact bank or cash ledger name in Tally | HDFC Current Account |
| Narration | Text | Transaction reference description | Being payment received via NEFT |
Bill-wise Mappings & Reconciliation
If your customer ledgers have **Bill-wise details** enabled, Tally requires you to link the receipt to a specific invoice:
- Against Reference (Agst Ref): Select this and specify the invoice number to settle an outstanding bill.
- On Account: Select this if the customer paid without referencing a specific bill, or if it is a lumpsum payment.
- Advance: Select this if the payment is an advance booking fee for future sales.
Note: If you do not map the bill-wise reference details in Excel, Tally will default the receipt allocation to "On Account", which leaves past bills marked as unpaid in your accounts receivable reports.
How to Import Receipt Vouchers
Method 1: Native Import via Tally Prime
- Go to Import > Manage > Mapping Templates > Create.
- Choose Receipts and locate your Excel sheet.
- Map columns (Date, Customer Name, Bank Ledger, Amount, Narration).
- Go to Import > Transactions to load the vouchers.
Method 2: Using TrulyInvoice Excel Validator
TrulyInvoice automates the receipt import process:
- Auto-Ledger matching: Automatically links customer names and bank ledgers.
- Pre-Reconciliation: It matches deposits from bank statement sheets to outstanding invoices using amount and date parameters.
- Pushes vouchers directly over localhost port 9000 at flat plans starting at ₹399/month.
Frequently Asked Questions
Q: Can I import receipts containing multiple invoice clearances?
A: Yes. If a customer paid ₹50,000 to clear two separate invoices of ₹25,000, your Excel sheet must split the lines or map multiple reference rows. TrulyInvoice handles multi-bill allocations natively.
Q: What is the TrulyInvoice flat pricing?
A: TrulyInvoice charges a flat rate of plans starting at ₹399/month for unlimited statement and invoice synchronization, enabling automated data entry directly to Tally Prime.
Sync Invoices and Statements Directly to Tally Prime
Stop spending hours on manual data entry. Simply upload purchase/sales invoices and bank statements, review mapped items, and sync transaction entries directly to Tally Prime. Get started at just plans starting at ₹399/month for unlimited sync.
Start Free TrialFounder & Chief Architect of TrulyInvoice