EduForEveryone Logo

Customer Reconciliation

Upload your customer statement / confirmation and your ar ledger (your books). Nothing is stored — files are processed in memory and the result comes back as a download.

BankSupplierCustomerIntercompany

How this works

  1. Have both documents open — your customer statement / confirmation and your ar ledger (your books), covering the same date range — and enter the four balance figures below exactly as shown on each.
  2. Export two files from the same documents: one for each side, from your bank or the other party's statement and from your accounting software or spreadsheet.
  3. Upload both below. Accepted formats: .xlsx, .xls, .csv, or .pdf. For spreadsheets, the first row must be the column headers (Date, Description, Amount, etc.) — not a title, a blank row, or an opening-balance line. PDF bank statements are read automatically and checked against the running balance; if we can't read one reliably we'll ask for the Excel or CSV export instead.
  4. Confirm the columns for each file once it's uploaded. Most of this gets guessed automatically; you just confirm it's right.
  5. Click Generate. You'll get an Excel file back with a reconciliation statement — including a tie-out check against the opening/closing balances you entered — a side-by-side comparison, and the full detail. Nothing is saved on our end.

Balances

Type these in from your actual documents — don't rely on us guessing them from the files. They're also used to double-check the uploaded transactions actually add up to the closing balance on each side.

Customer Statement / Confirmation

Balance the customer confirms or shows on their statement. Enter the amount outstanding as a POSITIVE number.

AR Ledger (Your Books)

Balance of this customer's account in your receivables ledger. Enter the outstanding amount as a POSITIVE number.

Before uploading a spreadsheet: the first row of each file must be the column headers (Date, Description, Amount…). Delete any title rows, blank rows, or opening-balance lines above the header row — the opening and closing balances go in the boxes above, not inside the file. (PDF statements are handled automatically.)

The statement or export received from the other side.

📄

Drag and drop your file here

or choose a file — .xlsx, .xls, .csv, or .pdf

Your own ledger for the same account.

📄

Drag and drop your file here

or choose a file — .xlsx, .xls, .csv, or .pdf

Still needed: enter all four balance figures, upload the customer statement / confirmation, upload the ar ledger (your books).

Found an issue or have a suggestion? We would love to hear from you at azlaneduforeveryone@gmail.com.