Audrey

Stop the frustration!
Free Bank Reconciliation in Seconds

What does Audrey do? It matches your bank statement to your general ledger and lists what may be missing.

Why is it free? We would like you to consider us for your payment processing.

Gather Your Bank Statement and Your General Ledger

From your bank: OFX, CSV, Excel or PDF (OFX is best).
The transaction detail report for one cash account, as CSV or Excel. One row per transaction.
Have several months to reconcile?

Reconcile a quarter or a year in one go. Audrey does the months in date order and carries anything still open (a check not yet cashed, a deposit in transit) into the next month, so it can clear there. Use one file that covers several months, or add one file per month below.

Add the other months here, up to 9 more files, each up to 8 MB. Choosing files here replaces any you chose here before. One run takes up to 25 MB in all and 25,000 rows a side: for more, split it into two runs.
The books for the other months, if they are in separate files. If your books are one file for the whole span, leave this empty.
Input a specific period or your opening and closing balance?

Leave these blank and Audrey takes the period straight from your statement. Fill them in only if you want a narrower range.

Leave blank if you like, but this is what proves the file was read correctly, and without it the result is marked unverified.
From the top of the statement, not the transaction list.
How do I get my General Ledger?
  1. Open the reports in your accounting software.
  2. Pick the report that lists every transaction on one account, one row each. It is usually called General Ledger Detail, Account Detail, Transaction Detail by Account or Account Inquiry. Not a Trial Balance, a Balance Sheet or a Summary: totals cannot be matched line by line.
  3. Choose the bank account on your statement, and only that one.
  4. Set the dates to the statement's month and about a week after it. Something banked on the 30th that cleared on the 2nd is timing, not a missing entry.
  5. Include every source: receipts, check runs, payroll and journal entries.
  6. Export it as Excel or CSV, and upload it here.

Still not sure? Email audrey@brooksidepayments.com and say which accounting software you use.

What happens to my files?

Your files are processed to produce your report and then deleted. We keep no copy, and there is no account. Holding your files would be a liability for us, so we don’t keep them.

Audrey matches on dates, amounts and descriptions. It never reads account numbers, EINs, SS# or addresses, so black those out before uploading if you prefer. Either way, the files are gone once your report is emailed.