MyBillBook-Bank Reconciliation Spreadsheet
Budget: ₹600 – ₹1,000 INR
I have twelve months of activity that must line up perfectly between my bank and MyBillBook. You will receive both the bank statement (PDF + Excel download) and the full MyBillBook sales/receipt export (Excel and CSV). The period to reconcile is the entire last financial year.
Your task is to comb through every line, match the two sources, and produce a single, easy-to-read Excel file that tells me at a glance where everything stands. Each row in the final sheet must show:
• Date
• Customer / Description
• Amount in Bank
• Amount in MyBillBook
• Difference
• Status (Matched / Missing / Extra / Wrong)
• Notes for any action required
While working you’ll need to:
– Flag entries that appear in the bank but nowhere in MyBillBook (unrecorded receipts).
– Flag sales that MyBillBook shows as paid but never hit the bank.
– Catch duplicates, wrong customer postings, or date mis-alignments.
I expect clean formulas, clear colour coding, and zero unexplained variances. If you have experience reconciling directly from MyBillBook exports you’ll find the layout familiar, but strong Excel and accounting skills are the real key.
Deliverables will be accepted once every statement line for the year is accounted for and the “Difference” column is all zeros on matched items.
Your task is to comb through every line, match the two sources, and produce a single, easy-to-read Excel file that tells me at a glance where everything stands. Each row in the final sheet must show:
• Date
• Customer / Description
• Amount in Bank
• Amount in MyBillBook
• Difference
• Status (Matched / Missing / Extra / Wrong)
• Notes for any action required
While working you’ll need to:
– Flag entries that appear in the bank but nowhere in MyBillBook (unrecorded receipts).
– Flag sales that MyBillBook shows as paid but never hit the bank.
– Catch duplicates, wrong customer postings, or date mis-alignments.
I expect clean formulas, clear colour coding, and zero unexplained variances. If you have experience reconciling directly from MyBillBook exports you’ll find the layout familiar, but strong Excel and accounting skills are the real key.
Deliverables will be accepted once every statement line for the year is accounted for and the “Difference” column is all zeros on matched items.