Finance Practice

Reconcile an itemised spend view to the books

Show where recorded money went while keeping uncertain classifications visible.

Preparation
One period export and bookkeeper or accountant review.
Steps
3
Difficulty
Moderate
Task
Build a reconciled spend view

Requires: Agree the period and established accounts with the bookkeeper or accountant. Gather the transaction detail and supporting records under approved access controls.

Uses: QuickBooks Online

Back to the Task: Build a reconciled spend view

Before you start

Prepare

  • Agree the period and established accounts with the bookkeeper or accountant.
  • Gather the transaction detail and supporting records under approved access controls.

Steps

Work through the method

Use the listed inputs and tools. Check the evidence when you need to verify a step.

  1. Export the period detail

    Export the agreed transaction detail and record the period, filters, source system, and export time.

    Step details and sources

    Why it matters: A defined source prevents a later total from mixing periods or filters.

    Input
    The books, agreed period, and export specification.
    Output
    A source-labelled period export.
    Tools in this stepQuickBooks Online

    Evidence for this step

  2. Group spend by established account

    Group recorded transactions by the existing accounts. Put unknown, personal, duplicate, and unsupported items in a separate queue.

    Step details and sources

    Why it matters: A separate queue keeps uncertainty out of reviewed spend totals.

    Input
    The period export and current chart of accounts.
    Output
    Grouped spend and an exception queue.
    Tools in this stepQuickBooks Online

    Evidence for this step

  3. Reconcile totals and request review

    Tie grouped totals back to the books. Ask the bookkeeper or accountant to decide classifications and any burn calculation.

    Step details and sources

    Why it matters: Professional review keeps reporting choices separate from mechanical grouping.

    Input
    Grouped spend, exception queue, and book totals.
    Output
    A reconciled view with reviewed and open items.
    Tools in this stepQuickBooks Online

    Evidence for this step

Success checks

Check the result

  • The period and export filters are recorded.
  • Grouped totals reconcile to the books.
  • Every uncertain item remains in the review queue.

Failure modes

What could go wrong

  • New categories replace the established accounts. Ask the accountant first.
  • Exceptions enter the reviewed total. Separate them.
  • A burn figure is treated as universal. Use the accountant-approved definition.

Tools

Choose tools

QuickBooks Online

An accounting workspace for receivables reports, invoices, receipt review, reconciliation, exports, recurring templates, and limited user roles.

Check fit, limits and pricing

Sources

Check the sources

Check what each source supports and where the advice has limits.