Guide

Getting credit card charges to the right house and cost code in QuickBooks Online

How custom and spec home builders code card swipes from the bank feed to a job and a cost code, so job cost reports show what each house really cost.

Short answer: Turn on Track expenses and items by customer, then code each charge on the credit card's own bank feed, not the checking payment, to the house in the Customer/Project field and to the product or service for its cost code. Split tickets that cover two houses, record returns against the same house and review uncoded charges every month.

Why card charges are where job costs go missing

Bills from subs and suppliers usually arrive with a job name on them. Card swipes do not. The bank feed knows the store and the amount, nothing else. A superintendent buys fasteners, a dumpster rental or a last-minute fixture, and unless someone ties that charge to a house and a cost code, it lands in a general materials account. The company P&L still adds up, but the job cost report for each house is short, and the house looks more profitable than it is. When our team reviews a builder's books, uncoded card charges are one of the most common reasons the job cost report and the real margin disagree.

Settings to turn on first

  • Track expenses and items by customer. In QuickBooks Online, this setting sits under Account and settings, then Expenses. It is what makes the Customer/Project field available on expenses and in the bank feed.
  • One record per house. Each house needs a customer, sub-customer or project to pick. Projects need QuickBooks Online Plus or Advanced. Pick one structure and use it for every house. Our QuickBooks Online setup guide covers the choice.
  • Products and services for your cost codes. If you want card charges to land by cost code, not only by house, each cost code needs a matching product or service with an expense account set. See our cost codes guide.
  • Connect the card itself. Connect the credit card account to its own bank feed. The card is a liability account, and the charges are coded there.

Want card charges landing on the right house every month? Request a Relationship Assessment.

Code the charge, not the payment

This is the mistake we fix most often. Each charge on the card is the cost. The monthly payment from checking to the card company is just moving money to pay down a liability. If the house is coded on the payment, or the payment is booked as an expense, the cost either never reaches the house or is counted twice. Code every swipe on the card's feed, and record the payment as a transfer or credit card payment with no job on it.

Coding a charge in the bank feed

  1. Go to Bank transactions and select the credit card account. Open the Pending tab.
  2. Open the charge. Confirm the payee.
  3. Pick the category. To feed job costing by cost code, use the product or service for that cost code where your bank feed view offers it. Intuit's categorize article notes you can record a bank feed expense using an account, a product or service, or both.
  4. Pick the house in Customer/Project.
  5. Post it. If QuickBooks offers a Match, only accept it when the same charge was already entered by hand, or by your project software, otherwise you end up with two copies.

One ticket, two houses

A single supply house run often covers two jobs. Use Split on the pending charge. Intuit's steps: switch Match to Categorize if needed, select Split, add a line per category and amount until the Difference shows $0, then select Split and add. Put the house on each line. If your screen does not show the house on a split line, post the charge, open the expense and set Customer/Project on each line. Keep the total unchanged so the card still reconciles.

Charges you already posted

If last month's charges were posted to a general account with no house, you do not need to delete them. Intuit's article on adding existing expenses to a project says to open each expense from Expenses and Bills, pick the project in Customer/Project on each line and save. Do this before the month is closed, or with your bookkeeper's sign-off if it is already closed.

Bank rules help, but only for repeat charges

Intuit says a bank rule can set the category, payee and more, and can split by percentage or amount, with up to 5 conditions per rule. Rules work well for charges that always go to the same place, like a software subscription or the office fuel card. They work poorly for a big box store you visit for every house, because the bank text does not say which house. Intuit also warns that auto-post rules add transactions without your review, so keep auto-post off for anything that should carry a house.

Receipts close the loop

Most of the time the receipt is the only place the house name lives. QuickBooks Online lets your team snap a receipt in the mobile app or email it in, then match it to the downloaded charge in the Receipts tab. A simple habit works: write the house name or address on the receipt, or in the supply house PO field, before the photo. A separate card for each superintendent also narrows each swipe down to a few houses.

If you use Buildertrend or JobTread

Card charges usually start in QuickBooks Online, so your project software has to pull them in. Buildertrend's troubleshooting page says QuickBooks expenses only reach its Job Costing Budget if they are itemized with products and services (not category details), coded to the linked customer or project, and, on cash basis, fully paid. Buildertrend's FAQ adds that a negative bill in Buildertrend creates a vendor credit that cannot match a card refund, so record returns as a credit card credit from the feed. JobTread pulls QuickBooks Online expenses into jobs with its Pull Expenses setting. See our JobTread sync guide and Buildertrend sync settings guide.

Returns and credits

A return should reduce the same house and cost code as the original charge. Code the credit to the same Customer/Project and product or service. If a return is coded to overhead while the purchase sat on the house, the house carries a cost it never kept.

Monthly checks

  • Every card reconciled to the statement.
  • No job-type purchases (materials, rentals, small tools for a job) left without a house.
  • Nothing sitting in Uncategorized Expense.
  • Card payments booked with no house on them.
  • Card totals by house tie to your project software. Our tie-out guide walks through it.

How we help

Our team codes card charges to the right house and cost code as part of every monthly close, follows up on missing receipts and ties each house out to your project software. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, our pillar guide on how to job cost a custom home, pricing or request a Relationship Assessment.

Sources

Common questions

Why can't I see the Customer/Project field on my credit card feed?

Turn on Track expenses and items by customer in Account and settings, under Expenses. You also need a customer, sub-customer or project set up for the house.

Should I put the house on the credit card payment?

No. Code each charge on the card's own feed. The payment from checking only pays down the card, so it carries no house and is not an expense.

How do I split one card charge between two houses?

Open the pending charge, switch Match to Categorize if needed, select Split and add a line per house and category until the Difference is $0.

Can a bank rule assign card charges to a house?

A rule can set the payee, category and more, but most store charges do not say which house they were for. Use rules for repeat charges and code job purchases by hand.

Why are my QuickBooks card charges missing from the Buildertrend budget?

Buildertrend pulls expenses only when they use products and services, are coded to the linked customer or project, and, on cash basis, are fully paid.

Can you code our card charges every month?

Yes. Our team codes card charges to the right house and cost code as part of each monthly close.

Related

By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.

See where your margin goes, house by house.

Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.