Short answer: QuickBooks cleanup in the Inland Empire fixes the file you have instead of starting over. A bookkeeper reviews it, fixes the chart of accounts, clears Undeposited Funds, closes invoices paid outside QuickBooks, redoes forced reconciliations, and sets up assets and loans correctly. You get reconciled accounts and a short written summary of what changed and why.
The usual QuickBooks mess
QuickBooks Online makes it easy to click "accept" on a bank feed. After a year of fast clicking, the file usually looks like this:
- Undeposited Funds with a balance nobody can explain
- Income counted twice: once from the invoice, once from the deposit
- Old invoices still open in accounts receivable
- Reconciliations that were forced, or never done
- Uncategorized Income and Uncategorized Expense with thousands of lines
- Loan payments booked as one expense line
- Truck and equipment purchases sitting in repairs and maintenance
How we clean a QuickBooks file
- Back up and review We look at the reconciliation history, the balance sheet and the open receivables and payables before we touch anything.
- Fix the chart of accounts Merge duplicate accounts, retire junk accounts, and add the ones your CPA needs.
- Clear Undeposited Funds Match each payment to the real bank deposit, or remove what is duplicated.
- Fix receivables and payables Close invoices and bills that were paid outside QuickBooks.
- Redo reconciliations Undo forced reconciliations and reconcile each month to its statement.
- Set up assets and loans Move big purchases to fixed assets and split loan payments into principal and interest.
Clean up or start fresh?
Sometimes a new file is faster. If the history is beyond repair and nobody needs it for tax years already filed, starting clean with correct opening balances can cost less than fixing every line. We tell you which way makes sense after the review, not before.
Signs your file needs it
Reports that swing wildly from month to month. A balance sheet that shows money in the bank you know is not there. A CPA who sends back the file with a long list of questions every year. If any of those sound familiar, the file is worth a review before another month goes in on top.
Keep it clean after
After a cleanup we set bank rules, lock past periods with a closing date, and leave notes on how things should be coded. If you move to monthly bookkeeping, we keep it that way. If you keep the books yourself, you have a file that is set up to stay right.
What you get at the end
The summary matters. If you have a CPA, an investor or a lender who saw the old numbers, they will want to know why the new ones are different. You hand them one page instead of answering twenty questions.
- Reconciled bank, card and loan accounts for every month in the cleanup
- A chart of accounts your CPA can work with
- Receivables and payables that show what is really owed
- Fixed assets and loans set up with correct balances
- A short written summary of what changed and why
Where we work
We keep books for businesses across Riverside County and San Bernardino County.
- Chino
- Corona
- Fontana
- Moreno Valley
- Murrieta
- Ontario
- Rancho Cucamonga
- Redlands
- Riverside
- San Bernardino
- Temecula
- Upland
Questions
What is Undeposited Funds and why is mine so big?
It is a holding account for payments received but not yet deposited. When payments are recorded but never matched to the bank deposit, the balance grows and income is often counted twice.
Will my CPA need to know about the cleanup?
Yes, if filed years change. We give you a summary of what changed so you can pass it on.
Can you clean up only last year?
Yes. We start from a balance we can trust and fix forward from there.
Do I need to stop using QuickBooks during the cleanup?
No. Keep invoicing and paying bills. We agree on the months we are fixing so day-to-day work does not get in the way.
What if there are years of problems?
We start from a point we can trust, often the last filed tax year, and fix forward.