Issued Cheque Reconciliation and Outstanding Cheque List

Issued Cheque Reconciliation and Outstanding Cheque List is an offline app (one HTML file in a zip) for the person who reconciles the company's bank account each month. You list the cheques you issued, type or import the cheque lines from the statement, and the app does the matching: a cleared date for every cheque that appears on the statement, an amount difference where the two disagree, a statement line that has no cheque behind it, and the outstanding total as at the statement date. It prints the outstanding list for your reconciliation file.

The problem it removes: Reconciling cheques is done by ticking a statement against a list, and the same questions come back every month: which cheques are still outstanding at the statement date, which cleared for a different amount, which cheque number is missing from the book, and which old cheque is now stale. This app does the matching and keeps the answer.

What is inside:

• Issued cheques per account with number, date, payee, amount and status Issued, Cleared, Void or Stopped
• Statement lines matched to cheques by number: a cleared date for every match, and a flag for an amount difference, a cheque not in the register, or a line that cleared although the cheque is void or stopped
• Outstanding cheques and their total as at the statement date of each account, and the statement balance less outstanding cheques to compare with your own books
• Stale and post-dated flags using a number of days you set, and chequebook leaves that are missing from the register
• A printable outstanding cheque report per account for the reconciliation file
• Example data you can load in one click, a Start here guide and an Honest limits panel
• JSON backup and restore, CSV export, and CSV import with a check of every row before anything is added

Who it is for: A bookkeeper, accountant or finance clerk who issues cheques from one or more accounts and reconciles them against monthly statements by hand or in a spreadsheet. One person at one computer.

What it is NOT: It does not connect to a bank or read a statement file by itself: you type or import the cheque lines. It is a reconciliation helper, not an accounting system: it does not post anything and does not give accounting advice. It is for cheques you issued, not for cheques you receive or post-dated cheque deposit handling. It is not legal, tax or accounting advice, it is not connected to any government system, bank or messaging service, and it does not file or send anything by itself. UAE e-invoicing is not part of it.

Your data stays on this device in your browser. Back it up with Export; clearing browser data loses it otherwise.

Verified by us: scripted tests in Chromium (139 checks through the real screens: adding, editing and deleting records in every table, required-field messages, backup then clear then restore, CSV export then import, keyboard order, print layouts rendered to PDF, no horizontal scrolling at 375 and 1280 pixels, no network requests) and an independent recalculation by a separately written Python evaluator of 2049 calculated values (25 randomised rows plus the example data) with 0 mismatches. Safari engine (WebKit): smoke test passed; Firefox: could not be launched. Not tested: Firefox beyond what is stated here, and no real printer was used (print layouts were checked as PDF).