Journal Entries

Import journal vouchers with several debit and credit ledgers per voucher. The same MULTI sheet also handles contra, receipt, payment, and sales or purchase vouchers without inventory.

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 – Set the columns

  1. Open the MULTI sheet.
  2. Pick the Voucher Type on the ribbon (Journal, Contra, Payment, Receipt, Sales, Purchase, Debit Note, Credit Note or your own type).
  3. Click Update Columns and enter how many debit and how many credit ledger columns you need (up to 30; up to 10 in the Basic edition). The sheet is rebuilt with those columns.
  4. Tick Bill Ref or Cost Centre if you need those columns.

Step 3 – Paste the entries

  1. One row = one voucher. Voucher Date is compulsory.
  2. Fill the debit ledgers and amounts, then the credit ledgers and amounts. Debit total must equal credit total in each row.
  3. Add voucher no., reference, instrument details and narration if needed.
MULTI sheet with journal vouchers, two debit and one credit ledger

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.

One debit and one credit per row, or journals with stock items or foreign currency? Use the bJournal sheet (Professional edition and above). It also has Multi Voucher Mode to export different voucher types in one run.

Advantages

Many Dr / Cr ledgers

Up to 30 debit and 30 credit ledgers per voucher (10 in Basic).

Any voucher type

Journal, contra, receipt, payment and custom types.

Cost centres

Cost centre per ledger line.

Bill references

Different bills and amounts against one ledger.

GST adjustment

GST adjustment journals supported.

Narration

Per voucher.

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

Get in touch

Share your details and we will get back to you.