I will clean up and reconcile your bookkeeping data in excel

China

I speak English

Excel and Financial Reporting, Cost Accounting

I turn messy finance data into clean Excel reports: monthly reports, direct-method cash flow, and reconciliations. Excel and Power Query: combine bank, ledger, and PayPal files; build cash-flow and c...
About this Gig

Duplicates, missing lines, totals that do not match? I will clean your bookkeeping data in Excel and reconcile it, so you or your accountant can work from a reliable file.

What you get:

  • Cleaned data: consistent dates, amounts and text; duplicates and blank or broken rows flagged or removed (your choice)
  • - A reconciliation of two sources (e.g. bank vs. ledger, invoices vs. payments) with matched, unmatched and difference lists
  • - A short exceptions summary of what needs your attention
  • - A clear audit trail: the original data is kept and every change can be traced
  • Process: you send files and what should match what; we agree matching rules (date window, amount, reference); I deliver the cleaned file and reconciliation, then revisions.
  • Notes:
  • - This is bookkeeping assistance done in Excel. I am not a licensed tax preparer, and this Gig does not include tax filing, tax advice or audit sign-off.
  • - I do not log in to your accounting software. You export the data and I return Excel files.
  • - AI only helps me draft the structure. I check every number myself.