Settlements: match your takings to the bank
Upload a bank statement or a card and UPI settlement report (CSV), and AirQR matches each row to your takings by method, amount and date or by the UTR. Rows with nothing behind them, takings nobody settled and takings that changed after matching go to the Problems list. Nothing is posted.
8 min read
India only (GST). Settlements is a tab in GST & accounts → For your accountant. Anyone who can see GST & accounts can look at it. Uploading a statement, marking a row's method, matching again and removing an upload need Change Accounting setup: the owner and the Accountant role have it. A person who sees only some outlets sees the statements of those outlets only.
What it does
Your till knows what was taken by card, UPI and online. Your bank (or your card machine's company) knows what was paid into your account. Settlements puts the two side by side, so your accountant can see what is missing in either place.
It does not post anything. It does not create a voucher, an entry in Tally or Zoho Books, or a change to a bill. The fee your card company kept (the MDR), the GST on that fee and the net they paid you are shown next to each row when the file has them, so your accountant can book them. That is all.
Upload a statement
- Open GST & accounts → For your accountant → Settlements and press Upload a statement.
- Choose what the file is:
- A bank statement: date, description, debit, credit and a reference (UTR). Only the credit (money in) column is read; debits are left out.
- A card or UPI settlement report: the report from your card machine, UPI or payment company, with the date, the gross amount, the fee (MDR), the GST on fee, the net paid and a UTR or batch number.
- Choose It is for: one outlet, or All outlets (only for a person who sees every outlet).
- Choose the CSV file. It can be up to 5 MB and cover one or two months (up to 62 days from its first row to its last); for a longer period, upload it in parts. Download it from your bank's or the company's portal as CSV, not as PDF.
- AirQR guesses which column is which. Check each box and correct it: Date, Credit or Gross amount, Dr/Cr column, UTR or reference, Method, Description and, for a settlement report, Fee (MDR), GST on fee and Net paid. Date and the amount are required; the rest are optional. If your file has one amount column and a separate Dr/Cr column, choose both: rows marked Dr (or Debit) are money out and are left out, rows marked Cr (or Credit) are read. An amount written like "1,234.50 Cr" or "500Dr" is understood too. The next upload starts from the choice you made last time.
- Choose Every row is paid by: Card, UPI, Online or Cash deposit, or Read it from the Method column when the file says the method on each row (words such as UPI, Visa, POS, NEFT or Cash are understood).
- Press Upload. AirQR adds the rows and matches them straight away: "12 rows added, 9 matched".
A row that is already in AirQR is not added twice, whichever outlet, method or columns you choose the second time: AirQR compares the row as it is written in the file. Upload the same file again and it says every row was uploaded before; upload an export that overlaps the last one and only the new rows are added ("3 already uploaded"). Rows without a readable date, with no amount, or that are debits are left out and counted ("2 left out").
If the column choice was wrong, press Remove on the upload, then upload it again with the right columns. You cannot remove an upload while the books are closed for a month it has rows in, or for a month of the takings it matched (a row dated in the first days of a month can settle takings of the month before): the owner reopens the month first.
How rows are matched
AirQR looks at your takings for each outlet, business day and method (card, UPI, online): the payments with their tips, less that day's refunds of the same method. Payments on Swiggy or Zomato orders that the platform collected are not included: their money comes in the platform's payout. Then, for each row:
- UTR or reference first. If the row's UTR or reference is the reference saved on one or more payments (or is written inside the row's description), the row is matched to those payments, whatever the amount or the date. A batch number shared by several payments matches all of them to the one row.
- Otherwise, a day's total. The row must have the same method, an amount within ₹1 of the day's total for that method (the row's gross, or its net when the file has one), and a date 0 to 3 days after the business day. A statement for All outlets may also match two outlets' totals of one day to one row.
Takings in a month whose books are closed are never matched, by an upload or by Match again. Each day's takings and each payment is used once. AirQR does not split a day across several rows, add several days into one row, or accept a part: a row either matches or it does not.
Cash is never matched to a bank row, except a row you mark as a Cash deposit. Choose Cash deposit when you upload a file of deposits, or, for a single row, set its method in Not matched. The row is then matched to that day's cash by the same rule.
A row without a method (a bank statement read from a method column that says something AirQR does not know) is not matched. It shows as No method, and you choose its method from the list beside it.
What is left over
The Not matched section of the tab lists three kinds of exception. The same three appear in Problems (see Accountant tools).
- In the bank, not in AirQR. A row in your statement with no takings behind it: a top-up, a transfer, a supplier refund, or takings you did not record. Check the method, record the payment, or accept it.
- In AirQR, not settled after 3 days. Takings of card, UPI or online that no row settled within 3 days. AirQR only raises this when an uploaded statement for that outlet covers those days and carries that method. If you have not uploaded a statement, or your statement stops earlier, nothing is flagged. The 3 days are fixed.
- Takings of a day changed after matching. A day's takings were matched to a row, and then a payment or a refund was recorded for that day, so the total is no longer within ₹1 of what the row covers. The problem shows the amount not covered. Check the new payment or refund, or accept it with a reason.
Each exception in Problems has Open Settlements (to match, set a method or remove a wrong upload), Accept (with a reason) and Note. A decision belongs to the GSTIN and period; once a month is closed these decisions are frozen, and the owner reopens the month to change them, as for any problem.
A statement for All outlets is listed under the first GSTIN of the business. Its rows are matched against all your outlets, and its exceptions are shown under that GSTIN.
The list and the CSV
- Uploads: each file, the outlet, its dates, how many rows, how many matched and not matched, who uploaded it.
- Not matched: the three exceptions above.
- Matched: each row with the day, outlet, method and amount it was matched to, and whether it was matched by UTR or reference or by amount and date. The fee, GST on fee and net are shown under a row that has them.
- Download CSV gives every row of the period with its status, plus the takings no row settled and the days whose takings changed. The amounts are in rupees.
On a phone the rows are a list. The tab follows the GSTIN and period at the top of the page.
Common questions
Does this post my MDR or the GST on it to my books? No. They are shown so your accountant can enter them in Tally or Zoho Books. AirQR does not post them.
Why is my UPI day not matched? Check that the row's method is UPI, the amount is within ₹1 of the day's UPI total (tips and refunds included), and the row is dated on the business day or up to 3 days after. A settlement that nets off a fee will match by its net only if the file has a Net paid column and you chose it. If your payment company settles several days in one row, AirQR does not match it: accept the exception with a reason.
Why was a row left out? It is a debit, has no amount, or its date could not be read. The upload says how many.
Can I connect my bank? No. Settlements reads a CSV that you upload.
Is the 3 days a setting? No, it is fixed at 3 days.
New to AirQR?
Try everything free for 28 days, no card needed. Already a customer? Sign in to follow these steps in your dashboard.
Still stuck? Contact support at support@airqr.in.
Related articles
- Your clients: every business you do the accounts forAn accountant who works for several businesses on AirQR sees all of them on one page, with each GSTIN's return period and dates, whether it is marked filed or overdue, books closed, the last Tally export, and the open problems and credit notes. Each business decides who sees its accounts.
- Accountant tools: Problems, Books closed and GST adjustmentsWhere an accountant sees every problem AirQR found for a GSTIN and month and decides what to do about it, closes the books for a month, adds GST adjustment lines with a reason, and proposes a refund the owner then does. Adjustments never touch a bill and never go to Tally or Zoho Books.
- Accounts for businesses without GSTOutlets with no GSTIN (state VAT only, or not registered) get an Accounts page with their sales, the VAT collected, a short VAT checklist, VAT and sales reports, Tally files without GST ledgers, and a ZIP for the accountant.
- GST credit notes: refund a bill and keep your GST rightEvery money-back on a settled bill makes a numbered GST credit note that prints, reaches Tally and Zoho Books and takes the right GST off your return. How tips, items, split bills, the time limit and Mark as filed work.