+91 93584 44502 | +91 92160 90617 | support@quick2tally.com
Quick2Tally

Cash Receipts and Payments

Import your cash book into Tally as receipt and payment vouchers, with voucher numbers, references and narration. It uses the same CASH & BANK sheet as bank statements.

Need help? Call or WhatsApp +91 93584 44502. Free installation and demo support.

Step 1 – Connect Tally

  1. Open your company in Tally.
  2. Open QuikAccount and go to the sheet you want to use.
  3. Click Connect Tally on the QuikAccount ribbon. The Tally Company box at the top right shows the company name, GSTIN, state and books start date. Check it is the right company.

Step 2 – Paste the cash entries

  1. Open the CASH & BANK sheet and select your Cash ledger in cell F1.
  2. Paste: Voucher Date (D), Voucher No. (C, optional), Ref Date (B, optional), Particulars (F, narration), Payment (L), Receipt (M).

Step 3 – Party / expense ledgers

  1. Enter the ledger in Party/Expense Name (column H), or use Auto Ledger and Fill Empty Party.
  2. Double-click a cell or press Ctrl+Shift+S to search the ledger list.
  3. A new ledger? Type the name; it is created on Validate.
CASH & BANK sheet used for cash receipts and payments

Step 4 – Validate and export

  1. Click Validate (or press Alt+Shift+V). Cells with errors turn red and are listed on the Error sheet with links to each cell.
  2. New ledgers are copied to the LedgerCreation sheet and new items to the ItemCreation sheet. Open that sheet, click Validate, then Export to Tally, and come back.
  3. Validate again until you see Validation Success.
  4. Click Export to Tally (or press Alt+Shift+E). The Report sheet shows every voucher with its status.

Advantages

Narration

Two particulars columns combined into the narration.

Bill reference

Against existing or new reference.

Voucher and reference no.

Your own voucher numbers kept.

Auto Ledger

Same rules as bank statements.

Trusted by Businesses Across India

Happy Clients

10,000

Transactions Processed

25,15,40,200

Partners

105

Trusted by 10,000+ Tally Users

For Utility, Support and Service

Trusted by Tally users

4.9-star Google rating based on 300+ reviews

Kamal Jain, FCA, CCA
Kamal Jain, FCA, CCA 1 review

Great software, User friendly & Superb support. All GST reports show accurate results. Multiple formats for each voucher to suit our needs. Whatever format of data you have, you can export it to Tally. Good job, QuikAccount team!

Sanjay Jain
Sanjay Jain 1 review

The software is user-friendly. It provides a lot of options to cater to your needs and gives results in desired format. It also asks for minimum data and most of the fields are either auto-calculated or imported from Tally, which makes working on this software much faster.

Prachi Shah, Senior Executive
Prachi Shah, Senior Executive 1 review

Superb tool to integrate Excel data with Tally. We have imported complex e-commerce reports with this tool and it imported large data accurately and very fast. The company provides a one-click import option for multiple e-commerce platforms.

Get in touch

Share your details and we will get back to you.