Monthly Excel Bank Reconciliations

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I need a detail-oriented bookkeeper to bring my bank activity into clear focus. The goal is simple: every month I want to see exactly where money comes in and where it goes out across more than five different bank accounts.

You’ll receive the raw statements plus any existing spreadsheets I keep. From there, please reconcile each account line-by-line, flag discrepancies, and roll the clean figures into an easy-to-follow Excel workbook that updates my running totals for income and expenses.

Deliverables
• One reconciled worksheet per account, per month
• A summary tab that aggregates monthly inflows, outflows, and ending balances
• Brief notes on any unmatched or suspicious items so I can act on them quickly

Accuracy and a neat file structure are more important to me than fancy visuals, but clear labeling and basic formatting in Excel will make the numbers much easier to digest. Once the first month meets both of our standards, we can set up a straightforward process for the following months to keep everything current.
data entry accounting excel finance financial analysis excel macros data analysis bank reconciliation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.