I will do bank reconciliation and ledger matching in excel
Former Bank Manager, Excel Reconciliations, Loan Calculators and Data Cleaning
About this Gig
Bank balance doesn't match your books? I'll find out why.
I'm a former bank manager with 8 years as an accountant and auditor, and an MBA in Finance. I reconcile your bank statement against your ledger or cash book in Excel, line by line, until the difference is zero, and I show you exactly how I got there.
What you get:
- Bank reconciliation statement agreed to zero
- Every bank line matched to its ledger entry
- Outstanding cheques, deposits in transit and timing items listed
- Errors flagged: wrong amounts, duplicates, missed charges and direct debits
- Ready-made journal entries for each adjustment
- Delivered in Excel, Google Sheets or CSV
The Premium package adds simple financial statements and a check of your internal controls.
No software needed. Send exports from QuickBooks, Xero, Tally, Zoho or any bank. I never need your bank or accounting login. Credit card statements work the same way.
Your data stays confidential, and you can mask account numbers before sending.
Not sure which package fits? Message me with the number of bank lines and months, and I'll tell you.
Service type:
Bank reconciliation
•
Credit card reconciliation
Financial software:
Other
Target country:
Canada
•
United Kingdom
•
United States
Gigs are not screened
Please note that there is no screening process for this service. We recommend that you message the freelancer and check all necessary details before placing your order. Read more about Financial services at Fiverr.
My Portfolio
FAQ
Do you need my bank or accounting software login?
No. Please never share logins. Send your bank statement and ledger exports (Excel, CSV or PDF).
My bank statement is a PDF. Is that OK?
Yes. I convert it to a spreadsheet first. CSV or Excel exports are quicker to work with if your bank offers them.
What if the difference doesn't reach zero?
I list every unexplained item with its likely cause and ask you to confirm. I never force a balancing figure.
Will you post the entries in my accounting software?
I give you ready-made journal entries. You or your bookkeeper post them, so you stay in control of your books.
Is my data kept confidential?
Yes. I use your files only for your order and delete my copy after delivery unless you ask me to keep it. You can mask account numbers.

