Business

QuickBooks import file: preparing bank transactions from India

Prepare bank transactions for a QuickBooks CSV import from India: one amount column or two, consistent dates, tidy descriptions and a five-row sample.

Editorial illustration for QuickBooks import file: preparing bank transactions from India

Before importing bank transactions into QuickBooks, decide whether your file will have one signed Amount column or separate Debit and Credit columns, make every date the same format, and trim the descriptions. Which layouts your version accepts is something to check on its import screen; the preparation below is the same either way.

One amount column or separate debit and credit columns?

Bank statements in India usually show withdrawals and deposits in two columns. Accounting import tools often accept either layout. Choose one and apply it to the whole file.

LayoutHow it looksWatch out for
Two columnsMoney out in Debit, money in in Credit; one of them blank on each rowBlank versus zero cells; numbers stored as text
One columnOne Amount column: outflows negative, inflows positiveForgetting to flip signs when the statement shows both as positives

Here is a sample of five hypothetical rows in the two-column layout.

DateDescriptionDebitCredit
01/11/2026Rent paid to landlord18000.00-
03/11/2026Client payment, invoice 42-45000.00
05/11/2026Internet bill1180.00-
09/11/2026Fuel2400.00-
12/11/2026Client payment, invoice 43-20000.00

The same five rows in one-column form become -18000.00, 45000.00, -1180.00, -2400.00 and 20000.00. Check: money in is 65,000, money out is 21,580, so the net movement is 43,420 either way.

How should dates be handled?

  • Use one pattern throughout, such as DD/MM/YYYY.
  • Be careful with 03/11 and 11/03: some software reads the first number as the month. If your region setting differs from your file, dates can swap silently or fail.
  • Confirm the date cells are real dates, not text: right-aligned usually means a true date.
  • Keep dates inside the period you are importing so nothing lands in a closed month.

How do I clean descriptions?

Raw bank descriptions in India are often long strings of UPI or NEFT codes. A readable description helps you categorise and search later.

  • Keep the payee name and a short purpose, for example Fuel or Rent.
  • Move long reference numbers to a separate Reference column if your layout has one.
  • Remove line breaks and stray commas inside a description; they can split one row into two.
  • Use the same wording for the same payee every month.

What should I test before the full import?

  1. Add up Debit and Credit columns in the sheet and write both totals down.
  2. Import the first five rows only.
  3. Check dates, amounts and direction (money in versus out) in the software.
  4. Compare the opening and closing balance with the real bank statement.
  5. Import the rest in one go, and compare totals again.

Where does SpendixAI help?

SpendixAI lets you upload a statement as PDF, CSV or Excel, review the rows before saving, and have them categorised. Its Export centre includes a QuickBooks template, and you can also download a standard all-transactions file. Compare the template with your QuickBooks import screen first; no tool can promise that every bank layout or every software version will line up.

What if the bank file has extra columns?

Statements downloaded from net banking often carry columns you do not need for an import: a running balance, a value date, a branch code, a cheque number. Decide column by column.

  • Running balance: usually not required. Keep it in a spare copy of the file to check your opening and closing figures, and delete it from the import copy unless your import screen asks for it.
  • Transaction date versus value date: choose the date the transaction took place, and use it consistently.
  • Cheque or reference number: keep it if your layout has a place for it; it helps later when you match a payment.
  • Header and footer lines such as account number and statement period: remove them so the first row of the file is the column heading row.

Never change an amount to make a total fit. If your sheet total and the statement do not agree, find the missing or doubled row instead.

Before you upload

  • One layout, applied to every row.
  • One date format.
  • Descriptions under control.
  • Totals matching the statement.
  • A trial import done.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports