HVAC Plumbing Electrical QuickBooks CleanupClean books before the batch posts

A payment that leaves the field software as a positive amount generally does two quiet things. It credits what the customer still owes, and it debits the holding account most shops call undeposited funds. That is the ordinary path, and it is the one we want, because the invoice the export created can then close.

Payment types follow that path unless someone set them to export as a journal entry instead. A journal can be right for a rare case. It is wrong when it skips the receivable, because the invoice in the books stays open while the field software thinks it was paid. We look for that split before we call the month done.

The first time the two systems talk, someone has to sign in. That login stays with the company. The form on this site never asks for a password, and we will not take one over the phone either. If the names of the accounts are not the same in both places, the touchless export stops, and that stop is useful.

Every item in the pricebook needs an account or the export fails. The chart was mapped when the file was set up. A new item added on a truck, with the account left blank, is the usual miss. The invoice looks fine in the field software and then refuses to land.

Purchase orders can travel as non-posting orders, or they can convert to a bill. Bill lines can be filtered by customer so the job still carries its cost. We ask which of those the shop actually uses before we touch a setting. Changing a setting to make one invoice move can change every invoice after it.

Two accounts should stay active. The receivable and the holding account are defaults, and turning them off breaks the path the export expects. We leave them on. If a report looks noisy because of them, the noise is information, not a reason to hide the account.

If an invoice changes after it has already exported, the vendor path is an adjustment invoice in the field software. That adjustment exports and applies to the original transaction in the books. Editing the books by hand and leaving the field software alone makes the next export fight the edit.

Before that adjustment is sent, name the months that are already filed. A change that reaches backward into a return that has gone out is a different conversation from a change that only touches an open month. An open month stays open in our notes until the bank total and the file total are the same number.

When the list finally ties, the feeling is plain relief, the kind that lets a Friday end. The holding account for that batch goes to zero, the job shows the payment, and the sales tax line matches the kind of work. A tied list is the finish line for that batch. No speech. Just rows that agree.

The integration overview names the products that can receive the export. QuickBooks Desktop, QuickBooks Online, Sage Intacct, Xero, and a CSV file are the ones on that list. Desktop Pro, Premier, and Enterprise, including the 2024 edition, are named as compatible. We ask which product the file is before we promise a path.

Intuit owns the QuickBooks name. This site is unaffiliated with Intuit and with ServiceTitan. We do not hold a trade license, and nothing here is an offer to repair a unit. The work is the list, the books, the statements, and the return that follows.

A CSV is the slow path, and sometimes it is the honest one. When the account names cannot be made identical, a file you can read row by row is safer than a touchless export that posts to the wrong account in silence. We would rather be slow on the first month than wrong on the twelfth.

A planned visit keeps equipment in ordinary running condition. A breakdown replaces or rebuilds something that failed. The books need both, on different items, because the return treats work that keeps property running differently from a cost that improves the property or restores it.

The record that saves the argument is plain. The visits were on a schedule, and the unit was running when the technician arrived. A shop that bills every visit as a repair, because the pricebook only has one item, hands the return a year that looks like one kind of work. We split the items before the batch posts.

On a bill that separates labor and materials, do not fold tax collected for a state into revenue. That tax is a liability until it is paid over. A permit fee that is stated separately, and that the contractor pays for the customer, may belong outside the revenue line. The invoice has to name the work. New work, a repair at a home, a repair at a place of business, or a planned visit.

Which of those four carry sales tax is not the same in every state. A rate belongs with the state rules, and this page leaves the number off. The rules for this state, including a repair and the annual entity report, are written on the state page. The national close still needs the four labels on the bill, because the return cannot invent them later.

Owners who expect to owe generally pay estimates through the year. For an individual the usual dates are 15 April, 15 June, 15 September, and 15 January of the next year. A corporation generally pays on the 15th day of the fourth, sixth, ninth, and twelfth months of its year. Those dates sit on the shop calendar beside the day the month is tied.

A shop that only looks at the return in March is looking at a year that already happened. The estimate dates are how the year stays current. Form 1040-ES is the individual voucher. Form 1120-W is the worksheet corporations use to figure the installments. We do not invent a penalty on top of the form. If the year is running ahead of the estimates, we say so while a payment can still be raised.

Zero estimates are not the same as a year with nothing to file. A return can still be due when the estimates were zero. Form 2210 is where an individual underpayment is figured, and Form 2220 is the corporate cousin. We ask, before December, whether the open months will change the picture. The relief is a January that is not a surprise.

Bring the last estimate voucher with the batch. If the voucher and the open jobs disagree, that disagreement is the conversation. We would rather raise a September payment than explain a shortfall after the year has closed. The same close, on the day we agreed, is what makes that conversation possible.

Bring the last export, the name of the product that received it, and one invoice that changed after it left. If a payment is sitting in the holding account, bring the job it should have hit. If a pricebook item failed, bring the item name. Twenty minutes is enough when those four things are on the table.

We work the past by cleaning the list that already posted wrong. We work the present by keeping the month that is open. We look toward the return while the year can still change. The same close, on the day we agreed, is the rhythm. The worry of a letter gets smaller when the list and the books tell the same story.