Learning Center
How QuickBooks Can Get Your Finances In Order for 2023
Put 2022 behind you by wrapping up those unfinished accounting tasks in QuickBooks.
You meant to clean up your accounting data by the end of 2022, but December is so busy. It was hard to do much beyond managing each day’s high-priority QuickBooks work. You’d catch up in January, you told yourself in December.
Now that it’s January, it’s time for a fresh start in a lot of ways, including your bookkeeping. But you can’t look ahead very effectively if you’re not sure where you are now. We recommend you take stock of the state of your QuickBooks company file. Are you caught up on bills? Do customers need to be invoiced? Are any of them past due on their payments to you?
QuickBooks is great at customer and vendor management, transaction processing, and reports. It can also serve as a barometer of your overall financial health. Let’s take a look at what you can do to update your company file and get ready for the challenges coming in 2023.
Who Do You Owe?
It’s easy to let some bills slip at the end of the year. Extra expenses in December may have caused you to run short on funds. Maybe you simply forgot, or you didn’t have a chance to deal with your payables. Whatever the reason, you can easily find out what bills you need to pay using QuickBooks.
The first thing you should do is run an A/P Aging Detail report. Open the Report Center (Reports | Report Center) and click Vendors & Payables. Locate the report and click the green arrow button. When the report opens, click Customize Report in the upper if you want to change the Dates. Then look to see if any bills are past due. Double-click on any row to see the original bill and pay it. You can also run the Unpaid Bills Detail report.
The Unpaid Bills Detail report
You’ve probably heard this before, but it’s important: If you’re past due on any bills, contact the vendors and let them know when they might expect payment. It makes a difference.
Who Owes You?
Just as you may have missed some bills in December, your customers might have let invoice payments slip. You need to find out who is in arrears. There are two reports that can help you here. Open the Report Center again and click Customers & Receivables. Run the A/R Aging Detail report and look at the Aging column to see if any customers have gone past due on payments. Open Invoices, too, can alert you to those customers.
How Should You Approach Past-Due Customers?
This is a problem for every small business. You don’t want to come on too strong and threaten the goodwill you’ve built up with your customers, but you have your own cash flow to consider. Here are some approaches:
Set up payment reminders so you’ll remember to send follow-up emails. Go to Edit | Preferences | Payments | Company Preferences. Answer the questions under Payment Reminders.
Automate reminders. Open the Customers menu and select Payment Reminders | Schedule Payment Reminders. This is a little complicated, so you may want our help with it. You’ll be creating schedules to automate the sending of invoices or statements at intervals you define. So you might dispatch an invoice to All customers when their payments are 15 days after the due date, for example. Click Add reminder to see the default text for the email accompanying the invoice and edit it.
QuickBooks can automatically send out reminder invoices and statements when customers are a specific number of days past due.
Send a handwritten note. This is only realistic, of course, if your customer base is small or isn’t often delinquent on payments. Handwritten notes are so unusual these days that they’re more likely to get noticed than an email.
Don’t know how to create statements in QuickBooks? Go to Customers | Create Statements. Here, you’ll tell QuickBooks who should receive statements and specify any other preferences you might have for their content. We’d be happy to walk you through this sometime.
How Do You Turn On Reminders?
Turning on the Reminders tool in QuickBooks can help keep you current on bills, invoices, and other critical tasks. Open the Edit menu and click Preferences. Click Reminders and make sure the box is checked under the My Preferences tab so Reminders will open every time you run QuickBooks. Click Company Preferences and tell QuickBooks which reminders you want to see and when.
QuickBooks’ Reminders tool can help you stay current with bills and invoices and other critical activities.
Making 2023 a Better Year Using QuickBooks Tools
Now that you know how to clean up your receivables and payables from 2022, we’ll go on next month to discuss steps you can take in QuickBooks to make 2023 a more productive—and hopefully, prosperous—year, including evaluating your inventory. We hope your holidays were good, and that you’re ready to take on a new year!
NEVER MISS A STORY.
Sign up for our newsletters and get our articles delivered right to your inbox.
Rose Tax & Financial
Cedar Crest, New Mexico 87008
Sat: 10:00am to 2:00pm
Check the background of your financial professional on FINRA's BrokerCheck
Avantax affiliated Financial Professionals may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment Services℠, Member FINRA, SIPC, Investment Advisory services offered through Avantax Advisory ServicesSM, Insurance services offered through an Avantax affiliated insurance agency. 3200 Olympus Blvd., Suite 100, Dallas, TX 75019. 972-870-6000.
The Avantax family of companies exclusively provide financial products and services through its financial representatives. Although Avantax Wealth Management® does not provide or supervise tax or accounting services, Avantax representatives may offer these services through their independent outside business. Content, links, and some material within this website may have been created by a third party for use by an Avantax affiliated representative. This content is for educational and informational purposes only and does not represent the views and opinions of Avantax Wealth Management® or its subsidiaries. Avantax Wealth Management® is not responsible for and does not control, adopt, or endorse any content contained on any third party website.
This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation.
The information being provided is strictly as a courtesy. When you link to any of the web sites provided here, you are leaving this web site. We make no representation as to the completeness or accuracy of information provided at these web sites. Nor is the company liable for any direct or indirect technical or system issues or any consequences.
For Important Information and Form CRS please visit https://www.avantax.com/disclosures.