GGaunita Docs

Everyday work

Banking and reconciliation

Import statements, match them to invoices and bills, and connect a bank feed.

#Accounts

Banking lists your bank, cash and card accounts with their balance in your books. Add more with + Add account. For accounts in a foreign currency, the card also shows the balance held in that currency, calculated from the payments you recorded in it.

#Import a statement

Choose Import CSV on an account. The file needs a Date column, a Description (or Narration / Particulars) column, and either Debit/Credit (or Withdrawal/Deposit) columns or a single signed Amount. Dates like 31/03/2026 are read day-first. Importing an overlapping statement again never creates duplicates, even when two real transactions look identical on one day.

#Reconcile

Imported lines appear under To review. For each line Books suggests what it is:

  • Match — if the narration contains an invoice or bill number, the amount equals what is outstanding, or the party's name appears, Books proposes that document with a confidence score. One click records the receipt or payment for exactly what the statement shows and marks the line matched.
  • Book as expense — for money out with no bill, pick a category.
  • Receipt on account — for money in with no invoice, pick the customer; it becomes a customer advance.
  • Exclude — hide a line you don't want to account for (you can restore it).

#Bank feed

To avoid uploading files, an account can receive transactions automatically. Choose Create feed URL on the account. Your bank aggregator or a small script can then POST transactions to that URL:

{ "transactions": [ { "date": "2026-04-05", "description": "NEFT ACME", "amount": 118000.00, "reference": "UTR123" } ] }

Positive amounts are money in, negative are money out. Repeats are ignored. Rotate URL if it is ever exposed.