Close

Our Blog

IM体育

Start 2022 Off Right: Clean Up QuickBooks
January is always such a transitional month. You’re trying to wrap up everything that didn’t get done during a hectic December. At the same time, you have to jump into the new year and start doing your regularly-scheduled work. It can be hard to tell sometimes which year you’re working on.

Don’t forget about QuickBooks while you’re catching up on 2021 and looking ahead to 2022. You probably don’t want to put one more item on your to-do list, but any steps you take now to ready the software for the new year will pay off. Once you start entering transactions and placing orders and welcoming new customers, it will help tremendously to have a clean slate.

Here are some suggestions for completing as much of the work you started in 2021 as you can.

Run four critical reports.

Bills can slip through without being paid in December because there’s so much going on. This applies to both you and your customers. You need to catch up on what’s owed to you and what you owe. So generate these four reports in QuickBooks:
  • A/R Aging Detail. Which of your customers are in arrears with their payments to you? How much do they owe you, and when should the money have come in? 

  • Open Invoices. Which invoices have not yet been paid? There will be some duplication with A/R Aging Detail, but this report isolates only unpaid transactions. 

  • A/P Aging Detail. Are you caught up with the money you owe other individuals and companies? This report will tell you. 

  • Unpaid Bill Details. Like Open Invoices, this report sets apart only the bills that have unpaid balances. 
Create statements for past-due customers.



One collection method you can use in QuickBooks if you don’t want to communicate directly with overdue customers is to send statements.

You’ll have to decide how hard you want to lean on customers who are late paying your bills when it’s so early in the year. Certainly, if some customers are more than 60 days late (30 days if they have sizable balances), you may want to make a phone call or at least send a personalized email asking them to fulfill their obligations.

But you can also send statements. These documents provide details of financial activity between you and your customers for a given period of time. Open the Customers menu and click Create Statements . Look over all of the options in the window that opens and indicate your preferences. If customers don’t respond to your statements within 10 days, then it may be time for a phone call.

Take a hard look at your inventory.

It may have been a while since you did this, but it’s really important to do it regularly – especially if you had a busy holiday season. The best way to start on this is to open the Vendors menu, scroll down and hover over Vendor Activities , and click Inventory Center.

If you don’t have a lot of inventory, you could just highlight each entry under Active Inventory , Assembly over to the left. The window that opens on the right side of the screen holds an enormous amount of detail about each item. But if you sell a lot of different kinds of items, that will take too much time. In that case, you might run one or more of the reports linked from this screen. Even the QuickReport can be helpful.



You can get a lot of information about individual items you sell in QuickBooks’
Inventory Center .

Tip: If you need to adjust the quantity you have on hand, click the down arrow next to Manage Transactions in the lower left and select Adjust Quantity/Value on Hand . You might consult with us if you’re running into this problem, and we can go over inventory issues with you.

Set Up Online Financial Connections

January is also a good time to be thinking about how you can better use QuickBooks in 2022. We tend to learn how to use the tools we need and not explore any further when we’re using any kind of software. QuickBooks is such a massive program that that’s understandable.

But there are two tools that can have tremendous impact on your daily workflow, your ability to get paid faster by customers, and your understanding of where you stand financially every day. They are:
  • Online Banking. Did you know that you can connect QuickBooks to many financial institutions and import your cleared transactions every day? That’s what the Bank Feeds Center is all about. If you sign up for this service, you won’t have to wait until your monthly statement comes to see what transactions have gone through. 

  • Online Payments. If you’re only accepting checks as payment from your customers, you’re probably getting paid more slowly than you might. Sign up for QuickBooks Desktop Payments, and you’ll be able to process credit cards, eChecks, and ACH payments.
We know you’re busy catching up from the holiday breaks right now. But if you need our help with anything we discussed in this month’s column, please reach out to us. We’re always available to set up a consultation.




Have a Question About This Topic?

I confirm this is a service inquiry and not an advertising message or solicitation. By clicking “Submit”, I acknowledge and agree to the creation of an account and to the Terms of Use and Privacy Policy .

NEVER MISS A STORY.

Sign up for our newsletters and get our articles delivered right to your inbox.

Back to Article List

'); mywindow.document.write(data); mywindow.document.write(' '); mywindow.document.close(); // necessary for IE >= 10 mywindow.focus(); // necessary for IE >= 10 mywindow.print(); mywindow.close(); return true; } function quote_standard() { var miscellaneous=0; var formName = document.ioq; $('#print').show(); /* START GLOBAL VARIABLES ***************************************************************************/ // Federal var form1040 = Math.round(120*1.3); var form1040A = Math.round(100*1.3); var form1040EZ = Math.round(60*1.3); var form1040X = Math.round(200*1.3); // State var form140AZ = Math.round(70*1.3); var form140AZPY = Math.round(90*1.3); var form140X = Math.round(90*1.3); var otherStateIncomeTax = Math.round(80*1.3); // Income var w2 = Math.round(10*1.5); var form1099R = Math.round(10*1.3); var k1 = Math.round(40*1.3); // Schedules var scheduleA = Math.round(110*1.3); var scheduleB = Math.round(20*1.3); var scheduleC = Math.round(120*1.3); var scheduleD = Math.round(40*1.3); var scheduleE = Math.round(200); var scheduleF = Math.round(100*1.3); var scheduleH = Math.round(100*1.3); var scheduleL = Math.round(20*1.3); var scheduleM = Math.round(20*1.3); // Forms var form982 = Math.round(80*1.3); var form2106 = Math.round(50*1.3); var form2441 = Math.round(40*1.3); var form4137 = Math.round(40*1.3); var form4562 = Math.round(30*1.3); var form4684 = Math.round(50*1.3); var form4797 = Math.round(140*1.3); var form5405 = Math.round(80*1.3); var form5695 = Math.round(80); var form6252 = Math.round(80*1.3); var form8283 = Math.round(40); var form8379 = Math.round(40*1.3); var form8396 = Math.round(30*1.3); var form8606 = Math.round(30*1.3); var form8824 = Math.round(150*1.3); var form8829 = Math.round(130); var form8863 = Math.round(50*1.3); // Income documents var incomeDocuments = Math.round(60); var incomeDocumentsAnswer = "Yes"; /* CALCULATES QUESTIONS NUMBER 2 ********************************************************************/ if (formName.DoYouHaveAMortgage_0.checked == true) { var doYouHaveAMortgage = 230; var doYouHaveAMortgageAnswer = "Yes"; } else { var doYouHaveAMortgage = 130; var doYouHaveAMortgageAnswer = "No" } /* CALCULATES QUESTIONS NUMBER 3 ********************************************************************/ if (formName.W2_0.checked == true) { var w2 = parseInt(w2) * parseInt(formName.W2_0_yes.value); var w2Answer = "Yes"; } else { var w2 = 0; var w2Answer = "No"; } /* CALCULATES QUESTIONS NUMBER 4 ********************************************************************/ if (formName.SelfEmployed_0.checked == true) { var selfEmployed = 170 * parseInt(formName.SelfEmployed_0_yes.value); var selfEmployedAnswer = "Yes"; } else { var selfEmployed = 0; var selfEmployedAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 5 ********************************************************************/ if (formName.DidYouLiveOutsideOfArizona_0.checked == true) { var didYouLiveOutsideOfArizona = parseInt(formName.DidYouLiveOutsideOfArizona_0_yes.value * 190); //didYouLiveOutsideOfArizona=Math.round(didYouLiveOutsideOfArizona*1.3); var didYouLiveOutsideOfArizonaAnswer = formName.DidYouLiveOutsideOfArizona_0_yes.value; } else { var didYouLiveOutsideOfArizona = 100; didYouLiveOutsideOfArizona=Math.round(didYouLiveOutsideOfArizona*1.3); var didYouLiveOutsideOfArizonaAnswer = 1; } /* CALCULATES QUESTIONS NUMBER 6 ********************************************************************/ if (formName.DidYouSellInvestments_0.checked == true) { // alert("Your fees could vary significantly depending upon the number and type of transactions. We can give you a firm quote when we meet. This quote is an estimate."); // Captures the quantity value of the drop down and multiplies it times the price. var didYouSellInvestments = (parseInt(formName.ScheduleD.value) * 5) + 50; if (parseInt(formName.ScheduleD.value) > 40) { didYouSellInvestments=didYouSellInvestments+((parseInt(scheduleD)-40)*3); } didYouSellInvestments=Math.round(didYouSellInvestments*1.3); var didYouSellInvestmentsAnswer = "Yes"; } else { var didYouSellInvestments = 0; var didYouSellInvestmentsAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 7 ********************************************************************/ if (formName.DidYouOwnRentalProperty_0.checked == true) { // Captures the quantity value of the drop down and multiplies it times the price. var didYouOwnRentalProperty = parseInt(scheduleE) * parseInt(formName.ScheduleEOwn.value); var didYouOwnRentalPropertyAnswer = "Yes"; } else { var didYouOwnRentalProperty = 0; var didYouOwnRentalPropertyAnswer = "No"; } if (formName.DidYouSellRentalProperty_0.checked == true) { // Captures the quantity value of the drop down and multiplies it times the price. var didYouSellRentalProperty = 250 * parseInt(formName.ScheduleESell.value); var didYouSellRentalPropertyAnswer = "Yes"; } else { var didYouSellRentalProperty = 0; var didYouSellRentalPropertyAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 9 ********************************************************************/ if (formName.ChildCare_0.checked == true) { var childCare = parseInt(form2441); var childCareAnswer = "Yes"; } else { var childCare = 0; var childCareAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 11 ********************************************************************/ if (formName.EnergyCredit_0.checked == true) { var energyCredit = parseInt(form5695) * parseInt(formName.EnergyCredit.value); var energyCreditAnswer = "Yes"; } else { var energyCredit = 0; var energyCreditAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 12 ********************************************************************/ if (formName.DonateNonCash_0.checked == true) { var donateNonCash = parseInt(form8283); var donateNonCashAnswer = "Yes"; } else { var donateNonCash = 0; var donateNonCashAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 13 ********************************************************************/ if (formName.BusinessUseOfHome_0.checked == true) { var businessUseOfHome = parseInt(form8829) + ((parseInt(formName.BusinessUseOfHome_0_yes.value) * 80) - 80); var businessUseOfHomeAnswer = "Yes"; } else { var businessUseOfHome = 0; var businessUseOfHomeAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 14 ********************************************************************/ if (formName.BusinessUseOfHome_0.checked == true) { var businessUseOfHome = parseInt(form8829) * parseInt(formName.BusinessUseOfHome_0_yes.value); var businessUseOfHomeAnswer = "Yes"; } else { var businessUseOfHome = 0; var businessUseOfHomeAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 15 ********************************************************************/ if (formName.CollegeTuition_0.checked == true) { var collegeTuition = parseInt(form8863) * parseInt(formName.Tuition_0_yes.value); var collegeTuitionAnswer = "Yes"; } else { var collegeTuition = 0; var collegeTuitionAnswer = "No"; } /* CALCULATES QUESTIONS NUMBER 16 ********************************************************************/ if (formName.IncomeDocuments_0.checked == true) { var incomeDocuments = parseInt(incomeDocuments); var incomeDocumentsAnswer = "Yes"; } else { var incomeDocuments = 0; var incomeDocumentsAnswer = "No"; } // Calculate the subtotal var subtotal = parseInt(doYouHaveAMortgage + w2 + selfEmployed + didYouLiveOutsideOfArizona + didYouSellInvestments + didYouOwnRentalProperty + didYouSellRentalProperty + childCare + energyCredit + donateNonCash + businessUseOfHome + collegeTuition + incomeDocuments); // create answer text var doYouHaveAMortgageAnswer = "2. Mortgage? " + doYouHaveAMortgageAnswer + " $" + doYouHaveAMortgage; var w2Answer = "3. W-2, 1099-R, SSA-1099, K-1 forms? " + w2Answer + " $" + w2; var selfEmployedAnswer = "4. Self-Employed? " + selfEmployedAnswer + " $" + selfEmployed; var didYouLiveOutsideOfArizonaAnswer = "5. State Returns: " + didYouLiveOutsideOfArizonaAnswer + " $" + didYouLiveOutsideOfArizona; var didYouSellInvestmentsAnswer = "6. Sold Investments? " + didYouSellInvestmentsAnswer + " $" + didYouSellInvestments; var didYouOwnRentalPropertyAnswer = "7a. Owned Rental Property? " + didYouOwnRentalPropertyAnswer + " $" + didYouOwnRentalProperty; var didYouSellRentalPropertyAnswer = "7b. Sold Rental Property? " + didYouSellRentalPropertyAnswer + " $" + didYouSellRentalProperty; var childCareAnswer = "8. Child Care? " + childCareAnswer + " $" + childCare; var energyCreditAnswer = "9. Energy Credit? " + energyCreditAnswer + " $" + energyCredit; var donateNonCashAnswer = "10. Donated more than $500? " + donateNonCashAnswer + " $" + donateNonCash; var businessUseOfHomeAnswer = "11. Business-use-of-home? " + businessUseOfHomeAnswer + " $" + businessUseOfHome; var collegeTuitionAnswer = "12. College Tuition? " + collegeTuitionAnswer + " $" + collegeTuition; var incomeDocumentsAnswer = "13. Earned Income Credit " + incomeDocumentsAnswer + " $" + incomeDocuments; // Check if existing client box is checked if (formName.ExistingClient_0.checked == true) { var existingClientAnswer = "1. Existing client? Yes"; var discount = parseInt(subtotal * .10); } else { var existingClientAnswer = "1. Existing client? No"; var discount = parseInt(subtotal * .20); } // Dependent discount check if (formName.DependentDiscount_0.checked == true) { var dependentDiscount = parseInt(subtotal * .5); var dependentDiscountText = "
Dependent Discount: -$"+ dependentDiscount; } else { var dependentDiscount = 0; var dependentDiscountText = ""; } var breakdown = existingClientAnswer + "
" + doYouHaveAMortgageAnswer + "
" + w2Answer + "
" + selfEmployedAnswer + "
" + didYouLiveOutsideOfArizonaAnswer + "
" + didYouSellInvestmentsAnswer + "
" + didYouOwnRentalPropertyAnswer + "
" + didYouSellRentalPropertyAnswer + "
" + childCareAnswer + "
" + energyCreditAnswer + "
" + donateNonCashAnswer + "
" + businessUseOfHomeAnswer + "
" + collegeTuitionAnswer + "
" + incomeDocumentsAnswer; var quote = breakdown + "
--------------------
Subtotal: $" + parseInt(subtotal) + "
Discount: -$" + parseInt(discount) + dependentDiscountText + "
--------------------
Total Only $" + parseInt(subtotal - discount - dependentDiscount + miscellaneous) + "! "; document.getElementById('quotearea').innerHTML=quote+'

If you have other transactions not mentioned above, your fees will be higher. This quote is an estimate. Please print this quote and bring it with you to your appointment. You must have a completed tax organizer to get the discount.'; return false; }