Accounts Payable Bookkeeping Support

I run a medium-sized enterprise and need ongoing help keeping our accounts payable and receivable accurate and up to date. At the moment every transaction lives in a set of linked Microsoft Excel workbooks, so you must be comfortable working in Excel and able to maintain formulas, pivot tables, and basic macros as you record new invoices, payments, and customer receipts.

Scope of work
• Record and code supplier bills and customer invoices.
• Track due dates, flag overdue items, and apply payments.
• Reconcile the A/P and A/R balances against bank statements to catch discrepancies quickly.
• Provide a concise weekly summary of outstanding payables, receivables, and any issues that need my attention.

Acceptance criteria
• All entries are double-checked for data entry errors.
• Balances in Excel tie out 100 % to the latest bank statement.
• Weekly report delivered by 5 p.m. every Friday in the agreed template.

If you are an Excel-savvy bookkeeper who enjoys keeping ledgers spotless, I would love to hear how you can streamline this part of our finance workflow.