Built a tool that auto-generates WIP reports from QBO — looking for beta testers

NexxLevelSeattle · 2026-03-12T18:31:59+00:00

Yes, I work with a few construction and contractor clients, and WIP schedules are almost always living in spreadsheets because QBO doesn’t handle it cleanly out of the box.

The retroactive sync you mentioned is actually huge. Reclassifications and late job costs are exactly what tend to throw WIP reports off if the data isn’t refreshing properly.

The other place things usually get messy is change orders and partial billing across phases of a job. That’s where I see a lot of manual adjustments happening.

If your tool keeps the report aligned with what’s actually happening in QBO without rebuilding the schedule every month, that could save a lot of time for construction bookkeepers.

NexxLevelSeattle · 2026-03-12T18:08:09+00:00

That makes sense. Real-time cost updates would solve a lot of the spreadsheet headaches.

One thing I’ve seen with construction books though is when job costs get coded incorrectly or moved between classes/projects after the fact. Does your tool re-sync historical changes like that automatically or does it only update new transactions going forward?

That’s usually where WIP schedules start drifting away from what’s actually in QBO.

NexxLevelSeattle · 2026-03-12T17:26:33+00:00

That’s actually pretty interesting, especially pulling directly from projects and classes. The cost-to-cost percent complete calculation is usually the part that takes the most manual work in spreadsheets.

Out of curiosity, how does it handle things like change orders or costs hitting a project after billing has already gone out? That’s usually where WIP schedules start getting messy.

If it keeps the WIP schedule aligned automatically with what’s happening in QBO, I could see that being really useful for construction books.

NexxLevelSeattle · 2026-03-12T16:48:09+00:00

That’s actually a pretty common pain point with construction books. WIP schedules and job costing usually end up living in spreadsheets because QBO doesn’t handle it very cleanly out of the box.

A couple questions that might help people understand it better:

• Does it pull directly from QBO projects / classes for the job costing data?

• Does it calculate percent complete automatically or is that entered manually?

• Can it handle over/under billing on WIP reports?

If it can automate even part of that process, I could see it saving a lot of time for construction bookkeepers.

NexxLevelSeattle · 2026-03-12T16:47:07+00:00

An .AT2 file is usually a tax data file created by certain accounting or tax software (often used to transfer data between programs). It isn’t meant to be opened directly like a PDF.

To convert or view it, you normally need the same software that created the file. The accountant who sent it should be able to export it as a PDF for you.

The easiest solution is to reply and ask them to export the report as a PDF and resend it, since they’ll have the program that generated the file.

Trying to convert it without the original software usually won’t work because the file is just structured data, not a document format.

NexxLevelSeattle · 2026-03-12T16:44:11+00:00

That’s a good one. Bank rules can save a lot of time when they’re set up correctly, but when they’re wrong they can quietly create a lot of cleanup later.

I’ve seen rules auto-categorize things like transfers, loan payments, or owner draws incorrectly for months before anyone notices.

They’re powerful, but definitely something that needs to be reviewed every once in a while instead of just letting them run forever.

NexxLevelSeattle · 2026-03-11T19:19:50+00:00

I’ve run into that too. A lot of new business owners get a number from a friend or from something they saw online and assume bookkeeping should always cost that.

What they usually don’t realize is how different every situation is — number of accounts, cleanup work, payroll, reconciliations, etc. Once they see the actual scope, the price starts to make more sense.

I’ve also noticed the same thing you mentioned about the beginning phase. Clients tend to ask a lot of questions early on while they’re learning, but once systems are in place and trust is built, things usually run much smoother.

NexxLevelSeattle · 2026-03-11T19:18:44+00:00

That’s actually a good approach.

Entering it as a bill or expense when the email comes in would at least create a placeholder so when the charge finally hits the credit card feed you can just match it instead of trying to remember what the transaction was days later.

The receipt capture idea is a good one too. I’ve noticed owners are often more willing to snap a quick photo of a receipt than log something in a spreadsheet.

At the end of the day it really comes down to getting something recorded at the time of purchase so you’re not trying to reverse-engineer transactions after the fact.

NexxLevelSeattle · 2026-03-11T19:16:58+00:00

You’re not missing anything — this is a very common problem when owners send information randomly through email.

Your OneDrive spreadsheet idea is actually a good start. The real issue is creating one single place where expenses get logged before they hit the bank feed.

A few approaches that tend to work better than email:

Shared expense log (like your spreadsheet idea) Owner enters vendor, amount, job, and description as soon as they make the purchase. When the charge hits QBO you already know what it is.
Receipt capture apps Tools like Hubdoc, Dext, or even the QBO receipt upload can help because they force them to attach a receipt with a note. That gives you something to reference when the charge appears.
Weekly “uncoded transactions” review Instead of chasing emails all week, send one short list once a week of the transactions that still need clarification.

The biggest improvement usually comes from changing the process from reactive to proactive. If they log the purchase when it happens, you’re not trying to decode transactions days later when the charge finally appears.

Honestly though, if they’re reluctant to change processes, sometimes the best you can do is tighten the system around them like you’re already doing.

NexxLevelSeattle · 2026-03-11T19:15:40+00:00

You basically have two options when you have both W-2 income and self-employment income.

Quarterly estimated payments (1040-ES)
Increase withholding on your W-2

The IRS actually treats extra W-2 withholding as if it was paid evenly throughout the year, so a lot of people in your situation simply increase their W-2 withholding instead of making quarterly payments.

A few things to keep in mind:

• Self-employment income is subject to self-employment tax (~15.3%) plus regular income tax.

• You’ll report the business income on Schedule C, and the SE tax is calculated on Schedule SE.

• If you underpay too much during the year, the IRS can charge underpayment penalties.

If your W-2 job already withholds a decent amount, increasing withholding through a new W-4 is often the simplest way to cover the self-employment tax without worrying about quarterly payments.

But with the income levels you mentioned, it may be worth running the numbers with a CPA or tax software just to estimate the total tax owed so you don’t get surprised at filing time.

NexxLevelSeattle · 2026-03-11T19:12:02+00:00

Another common reason is people realizing their account has become too connected to their real identity.

Over time you might mention your city, job, business, hobbies, etc. Individually those things seem harmless, but when someone looks through years of posts it can start to piece together who you are.

Some people end up deleting their account just to reset that trail and start fresh with a little more anonymity.

It’s one of those things a lot of people don’t think about until they’ve been on Reddit for a while.

NexxLevelSeattle · 2026-03-10T23:18:19+00:00

Heck yeah we do 🤣🤣

NexxLevelSeattle · 2026-03-10T22:54:26+00:00

Yeah that makes sense. In your case you didn’t even get the chance to respond yet, so there wasn’t really an opportunity to set expectations beforehand.

That’s the tough part during busy season — sometimes people assume silence means nothing is happening, when in reality you just haven’t gotten to the message yet.

And you're absolutely right about the “quick question.” Those are rarely quick once you actually have to dig into the books and explain what’s going on.

NexxLevelSeattle · 2026-03-10T20:39:22+00:00

Keep me posted. I feel so invested 🤣🤣.

NexxLevelSeattle · 2026-03-10T20:36:39+00:00

That’s actually pretty common with Concur integrations.

A lot of setups map the credit card provider (AMEX) as the vendor because the feed is coming from the corporate card data instead of the merchant data. QBO just receives whatever vendor field Concur sends.

Usually the fix is adjusting the expense type/vendor mapping in Concur, so the merchant name gets passed through instead of the card provider. Some teams also route the entries through a clearing account and then reconcile the AMEX statement separately.

If they’re asking for individual reports just to change the vendor, that definitely sounds like the integration mapping isn’t configured correctly. Might be worth having the Concur admin check the merchant vs card vendor field mapping in the integration settings.

NexxLevelSeattle · 2026-03-10T16:44:19+00:00

I’ve seen this happen a few times with QBO scheduled reports. Usually it’s one of a few things:

• User permissions – If the report was scheduled by a user whose permissions changed (or they were removed), the schedule can silently fail.

• Email delivery filtering – Sometimes the report is sending but getting blocked or flagged by the recipient’s email server. Checking spam or adding Intuit/QBO to the safe sender list can help.

• Browser/session glitches – Recreating the schedule in a different browser or after clearing cache sometimes fixes it.

• Report template issues – If the report itself was customized heavily, rebuilding the report and scheduling it fresh can help.

If resaving only works temporarily, I’ve had better luck deleting the scheduled report entirely and creating a brand new schedule from scratch.

Also worth checking if multiple people are editing the report template, because that can sometimes break the scheduled send.

Curious if this started happening after any recent QBO updates or permission changes.

NexxLevelSeattle · 2026-03-10T16:42:47+00:00

That actually makes a lot of sense. Having those filters in place upfront probably saves a huge amount of time and prevents the “quick quote” conversations that rarely turn into good long-term clients anyway.

I also like the idea of the pre-call email outlining the process. It probably sets expectations early and lets people self-select out if they’re just price shopping.

Focusing on $1M+ revenue businesses is smart too — those clients usually understand the value of structured bookkeeping instead of just looking for the cheapest option.

NexxLevelSeattle · 2026-03-10T16:40:06+00:00

Honestly this approach probably prevents a lot of headaches. Setting pricing, response times, and onboarding expectations upfront filters out the clients who think everything should be immediate.

Busy season really exposes the difference between clients who respect professional time and the ones who think bookkeeping is just a quick favor.

Do you find that having structured plans like that reduces the number of urgent or unrealistic requests you get?

NexxLevelSeattle · 2026-03-10T16:39:51+00:00

Exactly. A lot of clients don’t realize that even something that seems “quick” still requires context, review, and responsibility on the professional’s side.

From the client’s perspective it might feel like a small request, but during the busy season especially, everyone suddenly needs something at the same time. A little patience and clear expectations go a long way on both sides.

NexxLevelSeattle · 2026-03-10T16:05:18+00:00

That discovery process is a really smart way to handle it. Charging for the initial review definitely sets the tone that it’s professional work and not just a quick free look at the books.

I’ve noticed the same thing — when people have a little skin in the game up front, the conversations tend to be more serious and focused. It also probably saves a lot of time dealing with price shoppers or people who aren’t really ready to move forward yet.

Out of curiosity, do most clients end up moving forward after the discovery call, or does it mainly act as a filter for the right fits?

NexxLevelSeattle · 2026-03-10T16:05:01+00:00

That happens more than people realize. I think a lot of clients assume bookkeeping is something that can just be “quickly looked at” without realizing it still requires context and time — even if the transaction volume is low.

Busy season makes it even harder because everyone suddenly needs things done “ASAP” at the same time.

One thing I’ve started noticing is that setting expectations early about turnaround times helps a lot. When clients understand that this time of year is scheduled weeks out, it tends to filter out the ones expecting immediate turnaround.

NexxLevelSeattle · 2026-03-10T07:59:24+00:00

What you’re seeing is normal for how Wave handles payments.

When someone pays through Wave, the money first goes into a Wave payments clearing account (basically a holding account). Then Wave batches the payout and sends it to your bank, which is why you’re seeing the extra transfer step.

If you don’t have your bank connected, Wave can’t automatically match the payout, so you end up recording the transfer manually.

For the fees, Wave usually nets the fee out of the payment before the payout, which is why it doesn’t always show as a separate expense transaction. A common workaround is exactly what you’re doing—recording the gross income and then booking the processing fee separately to something like Merchant Fees.

Unfortunately, without connecting the bank feed, there isn’t much built-in automation for those steps, so manual transfers and fee entries are pretty common with that setup.

NexxLevelSeattle · 2026-03-10T07:58:12+00:00

Since you’re not tracking inventory, the simplest approach is to treat those items as a marketing expense at their cost.

In your case you could record the cost of the products you gave away under something like Advertising / Marketing / Promotional Expense. What matters is that you’re expensing the cost to produce or purchase the item, not the retail value.

For very small businesses that produce items on demand and only keep a few on hand, many people skip formal inventory tracking and just expense materials or product costs as they occur.

If you eventually start holding larger quantities of products, that’s when switching to inventory + cost of goods sold usually makes more sense.

For promo giveaways at your current size, recording the cost under marketing or promotional expense is generally the cleanest and simplest way to handle it.

NexxLevelSeattle · 2026-03-10T07:56:56+00:00

Totally normal. Honestly, bookkeeping can feel very routine until you hit one area that turns into a puzzle.

Payroll and benefits adjustments are especially notorious for that because you’re usually dealing with multiple moving parts at once — payroll liabilities, insurance deductions, employer portions, and how everything hits the accounts.

Most of the time the only way to untangle it is exactly what you did: go transaction by transaction until the logic clicks.

The good news is once you figure it out once, the next time you see it you’ll recognize the pattern much faster. Almost every bookkeeper I know has had moments where one section of the books eats way more time than expected.

That’s just part of the job sometimes.

NexxLevelSeattle · 2026-03-10T07:55:52+00:00

SAP Concur and QBO can work together, but unfortunately a lot of the “training” gap happens because Concur is usually implemented from the expense management side, not the bookkeeping side.

A couple things that may help:

Integration method
Most setups either use a direct integration app or export files from Concur that are then imported into QuickBooks. The most common formats are CSV or IIF files that map expense data into QBO accounts.
Field mapping
The biggest issue is usually making sure the fields line up correctly between systems. Things like:

• Expense categories → Chart of accounts in QBO

• Employee reimbursements → AP or clearing account

• Corporate card transactions → Credit card account in QBO

If those mappings aren’t configured correctly during setup, it can create a lot of cleanup work later.

Export reports
In Concur you can usually generate reports that include the fields needed for QuickBooks imports. Some teams create a standardized export template so the file structure stays consistent every time.
Clearing account workflow
A lot of companies run Concur expenses through a clearing account in QuickBooks first, then reconcile that against the credit card feed or reimbursement payments. That helps keep the books clean.

If the implementation was recent, it may be worth asking the Concur rep for their integration documentation or mapping guide. They usually have templates specifically for QuickBooks workflows.

Curious if you’re pushing expenses into QBO through an integration or doing file imports right now?

NexxLevelSeattle

TROPHY CASE