Case StudiesCorrecting Revenue Overstatement in a US Marketing Agency’s 2025 Books

Marketing agency / Cleanup Bookkeeping

Correcting Revenue Overstatement in a US Marketing Agency’s 2025 Books.

A full-year 2025 bookkeeping cleanup for an anonymized small marketing agency with around 300 transactions per month.

Publication: anonymized project details.

Abstract folders and report shapes representing an organized bookkeeping cleanup

At a glance

PROJECT OVERVIEW.

Client
Small marketing agency
Industry
Marketing agency
Software
QuickBooks Online
Services
Cleanup Bookkeeping
Project period
Full-year 2025 bookkeeping cleanup
Duration
About 3 weeks
Transaction volume
Around 300 transactions per month

Measured details

KEY METRICS.

100%of accounts reconciled
~300transactions per month
~120missing transactions imported
~20%income overstatement addressed

Where the work began

THE SITUATION.

The client had a full year of bookkeeping that needed to be corrected. Their QuickBooks Online accounts were unreconciled, not all transactions had been categorized, and the financial records contained several recording errors.

  • Payments were not properly applied to invoices, leaving balances in Undeposited Funds.
  • Income was overstated by around 20% because of incorrectly recorded payments.
  • Stripe bank fees needed to be accounted for in actual deposits.
  • Credit card payments had been incorrectly paired.
  • Some bank accounts were missing from QuickBooks Online.
  • Duplicate transactions needed to be reviewed.
  • Transfers between bank accounts had been recorded as income or expenses.
  • Bank and credit card book balances were incorrect.
  • The owner’s investment had been classified as a liability instead of equity.

The assignment

TASK.

Clean up the entire 2025 bookkeeping period, correct the recording errors, account for missing transactions, reconcile all accounts, and prepare an accurate Balance Sheet and Profit & Loss for the client’s CPA to use for tax filing.

What the engagement covered

SCOPE OF WORK.

The engagement covered the full-year 2025 QuickBooks Online period, including Stripe and accounts receivable payment applications, Undeposited Funds, bank fees, credit card matching, duplicate review, missing bank activity, transfers, book balances, chart-of-accounts classifications, and account reconciliations.

The approach

ACTION.

The work started with the Stripe and accounts receivable issues because payments needed to be corrected before recorded income and deposit balances could be relied on. Credit card reconciliations required undoing incorrect reconciliations before payments could be properly paired. Duplicate transactions were reviewed individually rather than simply removed because they looked similar.

The bookkeeping work

WORK PERFORMED.

  1. Corrected accounts receivable payment applications and Undeposited Funds balances.
  2. Accounted for Stripe bank fees included in actual Stripe deposits.
  3. Corrected credit card payment matching after undoing incorrect reconciliations.
  4. Reviewed and corrected duplicate transactions individually.
  5. Manually imported around 120 missing transactions.
  6. Added missing bank account activity to QuickBooks Online.
  7. Corrected transfers recorded as income or expenses.
  8. Corrected bank and credit card book balances.
  9. Corrected chart-of-accounts classifications, including reclassifying the owner’s investment from a liability to equity.
  10. Reconciled all accounts.

Reported outcomes

RESULTS.

  • 100% of accounts were reconciled.
  • Accurate Balance Sheet and Profit & Loss were prepared for the client’s CPA.
  • The client was able to file their taxes on time.
Before and after summary
MetricBeforeAfterChange
Account reconciliationAccounts unreconciled100% reconciledAll accounts reconciled
Income accuracyAround 20% overstatedCorrectedOverstatement addressed
Missing transactionsMissing entriesAround 120 manually importedTransactions added
Financial statementsIncorrect balances and classificationsAccurate Balance Sheet and Profit & Loss preparedCorrected financial reporting
Tax filingBooks required cleanupClient able to file on timeFiling completed on time

The before/after table reflects the supplied project description. Supporting QuickBooks Online reports, bank and card statements, Stripe reports, and CPA review were not supplied for publication, so this page does not present independently verified documents as evidence.

An insight from the work

LEARNING.

This project reinforced why reconciliation is not simply matching transactions until the accounts balance. Payments, deposits, and transfers had to be corrected first; otherwise, the reconciliations would not address the underlying errors.

Ready when you are

Want to understand what your books need next?

Start with your books