Weekly Bookkeeping Checklist

Weekly bookkeeping cadence a bookkeeper or fractional controller runs in QuickBooks Online or Xero to keep the books current — transactions categorized, A/R and A/P worked, payroll posted, and a cash flow snapshot delivered to the client.

5 sections 22 steps Collects data
1

Transaction Review

  1. Pull bank and credit-card feeds
    • Refresh the Plaid / direct bank feeds in QBO or Xero for every operating, savings, and credit-card account. Flag any account where the feed has been disconnected for more than 48 hours — stale feeds are the most common cause of duplicate transactions when they reconnect.

  2. Categorize new bank-feed transactions
    • Work the For Review tab to zero. Apply or update bank rules where vendor patterns repeat. Anything that genuinely cannot be coded goes to Ask My Accountant with a note — never let suspense become the dumping ground.

  3. Verify expense account coding
    • Sort the week's transactions by GL account and scan for misposts — meals coded to office supplies, owner draws coded to wages, capitalizable assets expensed to repairs. Reclass directly in the transaction rather than via journal entry so the bank feed memo stays attached.

  4. Reconcile through the prior weekend
    • Run a mini-rec for each bank and credit-card account through the most recent weekend. Tie book balance to the bank's available balance net of in-transit items. Flag any uncleared check older than 30 days for the stale-check follow-up step below.

    Collects list Collects paragraph
  5. Investigate reconciliation variance
    • Triangulate the variance: duplicate bank-feed entries, missing deposit, NSF return not booked, or wire fee that posted without a matching bill. Document the root cause in the workpaper so the same gotcha is recognized faster next week. Escalate variances over $1,000 to the controller before close.

2

Accounts Receivable

  1. Issue the week's customer invoices
    • Generate invoices for fixed-fee retainers, time-and-materials hours from the prior week, and any milestone-based deliverables. Verify the customer PO number, sales-tax jurisdiction, and payment terms before sending — corrections after delivery delay collection by a full cycle.

  2. Apply customer payments to invoices
    • Match ACH, wire, lockbox, and Stripe deposits to the open invoices in QBO. For partial payments, post against the oldest open invoice unless the remittance specifies otherwise. Never leave deposits sitting in Undeposited Funds past Friday — that's how A/R aging drifts from the GL.

  3. Work the A/R aging report
    • Run the 0/30/60/90 aging. Send first reminders at 7 days past due, second reminders at 21 days, and call the customer at 45 days. Anything in 90+ goes to the collections-decision step below for a write-off or escalation call.

    Collects list Collects file
  4. Decide on 90+ day balances
    • For each balance over 90 days, choose one path: escalation call from the controller, payment plan with signed terms, or bad-debt write-off via credit memo. Document the decision and notify the partner before adjusting the GL — write-offs hit revenue and cannot be reversed without a journal entry.

3

Accounts Payable

  1. Enter vendor bills from the inbox
    • Pull bills from Bill.com, Hubdoc, Dext, and the AP email inbox. Code each to the correct GL account, class, and customer/job where billable. Confirm a current W-9 is on file for any new vendor — missing W-9s are the #1 cause of January 1099 chaos.

  2. Run three-way match on inventory bills
    • For inventory and capex purchases, tie the vendor bill to the PO and the receiving document. Quantity and unit-price exceptions go back to ops for resolution; do not approve a bill that doesn't match without a documented variance memo.

  3. Schedule the weekly check run
    • Filter the AP aging for bills due in the next 10 days. Prioritize early-pay discount terms (2/10 net 30 is worth taking), then critical vendors, then the rest. Submit the payment batch to the partner for release in Bill.com — separation of bill entry and payment release is a basic anti-fraud control.

    Collects number
  4. Reconcile vendor statements
    • For top-spend vendors, tie the vendor statement to the open AP detail. Investigate any invoice on the statement that is not in the GL — duplicate billing, missed credit memos, and unauthorized charges surface here.

4

Payroll

  1. Confirm whether payroll runs this week
    • Bi-weekly schedules skip a week each month. Confirm against the pay calendar in Gusto, ADP, or Rippling before opening payroll prep — running an off-cycle batch by mistake creates duplicate withholdings that take weeks to unwind.

    Collects list
  2. Validate timesheets and PTO
    • Confirm all hourly timesheets are submitted and approved by the manager. Reconcile PTO requests against the leave balance. Flag any employee with negative PTO or uncoded overtime for HR before the run is committed.

  3. Process the payroll run
    • Submit the run in the payroll platform after a final review of gross-to-net. Confirm the federal deposit schedule (semiweekly vs. monthly per the lookback period) — late deposits trigger 2% / 5% / 10% penalties under IRS Pub 15.

  4. Post the payroll journal to the GL
    • Import the payroll journal from Gusto/ADP into QBO. Tie gross wages, employer taxes, and net pay to the bank debit. Accrue any wages earned but not yet paid if the period-end falls mid-pay-period.

  5. Update employee record changes
    • Apply pay-rate changes, address updates, W-4 revisions, 401(k) deferral changes, and benefit elections in the HRIS and payroll platform. Garnishment orders take effect on the next available pay date — confirm the order copy is filed in the employee record.

5

Reporting & Client Delivery

  1. Build the 13-week cash flow forecast
    • Refresh the rolling 13-week forecast in Float, Dryrun, or the firm's spreadsheet template. Inputs: A/R aging (collections by week), A/P aging (commitments by week), payroll calendar, debt service, and recurring fixed costs. Highlight any week that drops below the minimum operating cash threshold.

  2. Run P&L versus budget
    • Generate MTD and YTD P&L with budget and prior-year comparisons. Investigate any GL account with greater than 10% variance to budget — the explanation goes in the management commentary, not in a follow-up email.

  3. Write management commentary
    • Three to five bullets the owner should care about: cash position vs. last week, top revenue/expense variances, A/R concerns, upcoming large outflows. Avoid restating numbers the report already shows — the value is in the interpretation.

  4. Deliver the weekly report package
    • Post the report package and commentary to the client portal (Karbon, TaxDome, or Liscio). Lock the prior week in QBO with a close-date password so retroactive edits route through a journal entry instead of silently changing locked-period numbers.

    Collects file Collects signature

Use this template

Copy it to your account, customize the steps, and run it with your team in minutes.


Sections 5
Steps 22
Category Accounting
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Weekly Bookkeeping Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.