Learning Center
We keep you up-to-date on the latest tax changes and news in the industry.
How to Clean Up QuickBooks for 2020
Yes, it’s here again: the end of the year. You probably have a lengthy to-do list full of tasks that must be done before December 31. There’s one task—or rather, a series of tasks—that you should definitely add to that list: year-end QuickBooks cleanup. Following the guidelines provided here will do three things. It will:
- Ensure that you’ve processed every 2019 transaction (or that you know why you can’t).
- Give you a sense of closure, knowing that you’ve dealt with all your 2019 financial data.
- Allow you to start your 2020 QuickBooks activities with as clean of a slate as possible.
Before you start looking at transactions and running reports, check to make sure that your fiscal year is recorded correctly in QuickBooks. Open the Company menu and select My Company. Click the pencil icon in the upper right to open the Company Information window, then click Report Information in the tabs to the left. This window opens:
Is your company’s fiscal year recorded correctly in QuickBooks? If not, please contact us. Don’t try to fix this on your own.
Account For All Of Your Income
You certainly want to have received all the money owed to you by December 31 if at all possible. So, run a report to see which customers have outstanding, overdue balances. Open the Reports menu and select Customers & Receivables | A/R Aging Summary.
The first column here will read Current. You don’t have to worry about these customers. It’s the next four columns that will require follow-up. If your default payment terms are 30 days, you’ll see columns for 1-30, 31-60, 61-90, and >90. Customers with dollar amounts in those columns have not met their obligations and are past due by those date ranges.
Note: If your default terms are different (like 15 days), you’ll need to customize the report. In the toolbar at the top, you’ll see a field labeled Interval (days). Change it to reflect your own default terms and click Refresh in the upper right corner.
If your report contains only a sea of zeroes in those four columns, everyone is paid up. If not, you can send statements
to anyone who is at least one day past due to remind them of what they owe. Open the Customers menu and select Create Statements to see this window:
Partial view of the Create Statements window
Make sure the Statement Date is correct since QuickBooks will use this to calculate aging. Then you can either enter a specific Statement Period or request All open transactions as of Statement Date. If you choose the latter, you’ll most likely want to limit the statements to customers whose payments are overdue. So, you’d click in the box in front of Include only transactions over [your number here] days past due date.
Below these options, you’ll be able to indicate which customers should receive statements. The most common choice is All Customers (who fall into the group you just defined), but you can also send to one or multiple customers, for example. QuickBooks will display a list if you select one of these. The right pane of this window contains several additional options that you can check or uncheck. When you’re satisfied, you can Preview, Print, or E-mail the statements.
Pay Outstanding Bills
You should also try to settle your Accounts Payable before the end of the year. Open the Reports menu and select Vendors & Payables | A/P Aging Summary. Look for dollar amounts in the columns that show aging beyond the first column. You can also run the Unpaid Bills Detail report and look at the Aging column, as pictured here:
Look in the aging column of this report to see which bills are past due and by how many days.
Note: QuickBooks has multiple Preferences that relate to reports and aging. We can go over these with you if you haven’t explored them.
There are other tasks you should complete before December 31, some of which may require our assistance. These include reconciling all accounts, running year-end reports, and clearing any deposits that remain in the Undeposited Funds account. We’re here if you need us now, otherwise we can connect in the New Year.
Want our best tax and accounting tips and insights delivered to your inbox?
Sign up for our newsletter.
Benefits of having a business advisor
Your CFO, Reimagined as a Financial Doctor
Diagnosing root causes, prescribing solutions, and guiding your property business toward long-term wealth.
Our CFO | Advisor
Raquel is a passionate business owner. Now, she is returning to her grassroots with a twist - guiding clients with her expertise as a CPA, she can advise your company as your trusted CFO and Advisor.
-
Raquel Deodanes, MS, CPA
Co-Founder✅ CPA with Real-World Experience – I help property managers stay profitable, tax-efficient, and cash flow positive.
✅ Tax Strategist – Former advisor at California’s revenue agency.
✅ Trusted by 4,000+ Businesses – Experience across CA, FL, TX, NV, and beyond.
✅ Real Estate Investor – I understand the financial realities of property management.
✅ Entrepreneur – I’ve built businesses and know the challenges you face.
Frequently Asked Questions
-
We diagnose financial inefficiencies, treat problems like poor cash flow or rising costs, and guide you to long-term financial health. That includes cleaning up your books, forecasting cash flow, optimizing operations, and helping you grow your portfolio with confidence — just like a doctor builds a custom care plan for a patient.
-
Bookkeepers record transactions. CPAs file your taxes. We connect the dots — helping you understand your numbers, strategically improve them, and make smarter decisions throughout the year. We work alongside your existing team to drive performance, not just compliance.
-
If you're unsure where your cash is going, struggling with rising costs, planning to scale, or just tired of reacting instead of planning — now is the right time. We help you get ahead of problems, not just clean up after them.
-
Clients typically see improved cash flow, cleaner books, higher NOI, better financial reporting, and a lot less stress at tax time. More importantly, you gain clarity, confidence, and control over your business — and a partner who helps you grow it.
Pricing
Painless, transparent pricing.
Let us take away your stress and give you back your time. Choose your perfect package today.
Base
-
Dedicated finance expert
-
Bookkeeping with accrual basis
-
Includes P&L, balance sheet, and cash flow statements
Core
-
Includes everything in Base, PLUS
-
Industry KPIs and financial ratios
-
Monthly virtual 1-hr meetings
-
Monthly rolling budget forecasts
Growth
-
Includes everything in Base, CORE
-
Budget vs. actuals variance analysis and review
-
Payroll and HR Platform