EduForEveryone Logo

Intercompany Reconciliation

Upload your counterparty ledger and your your ledger. 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 counterparty ledger and your your ledger, 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.

Counterparty Ledger

Opening and closing balance of the intercompany account in the counterparty's books. Both sides must be entered with the SAME sign: if you agree an amount is outstanding, enter it as a positive number on BOTH sides, even if one ledger prints it as a credit/negative balance.

Your Ledger

Opening and closing balance of the intercompany account in your entity's books, entered with the same sign convention as the counterparty side (outstanding balance = positive).

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 counterparty ledger, upload the your ledger.

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