Part-Time Bookkeeping & Payroll Reports
Budget: $30 – $250 USD
The business needs clean, up-to-date books every month, built entirely in Excel. Each week you will categorise expenses as they arrive; at month-end you’ll reconcile every bank and credit-card statement, then generate a P&L, balance sheet, and cash-flow overview I can share with my accountant.
Although QuickBooks or Xero experience is useful, the source of truth must remain in Excel so all worksheets and summaries you create have to stay formula-driven and easy for me to audit later.
Payroll is part of the brief as well: bi-weekly runs, tax and benefit withholdings recorded, and year-end files ready for submission.
Deliverables
• Expense ledger updated weekly in Excel
• Bank and card accounts fully reconciled by the 3rd business day each month
• Monthly P&L, balance sheet, and cash-flow reports (Excel)
• Payroll processed on schedule with supporting registers
Acceptance criteria: zero unreconciled transactions, reports balance to bank totals, and files are formatted so I can refresh figures without re-work.
Although QuickBooks or Xero experience is useful, the source of truth must remain in Excel so all worksheets and summaries you create have to stay formula-driven and easy for me to audit later.
Payroll is part of the brief as well: bi-weekly runs, tax and benefit withholdings recorded, and year-end files ready for submission.
Deliverables
• Expense ledger updated weekly in Excel
• Bank and card accounts fully reconciled by the 3rd business day each month
• Monthly P&L, balance sheet, and cash-flow reports (Excel)
• Payroll processed on schedule with supporting registers
Acceptance criteria: zero unreconciled transactions, reports balance to bank totals, and files are formatted so I can refresh figures without re-work.