So, recently, I got a client from here on Reddit who wanted me to migrate over four years of historical data from Excel to QuickBooks Online for account reconciliations against their existing sheets, and also find a way to make the process relatively straightforward going forward.

I'd used QB a long while back, but I'd forgotten most of it since that was more of a favour to a colleague than anything else.

Anyways, one phrase she kept uttering as we discussed the project was "I hate QB." Honestly, I found it funny. My thoughts at the time were, it can't be that bad. That was until I found and browsed this sub. Oh dear!

When I started working on the project, I perfectly understood why most on here shit on it. The common sentiment across both subs seems to be recommending alternatives.

That said, the first annoying thing I encountered was how clunky the user experience is. You can't just import your data; it has to be mapped correctly to how QB expects it. Fair enough, I guess. But the amount of data cleaning and modelling I had to do to get everything mapped correctly to QB's invoices default format to generate the corresponding AR was painstaking.

The client initially wanted me to use journal entries (JEs), which would have been a complete clusterfuck wrt to their data but flagged it early. Then there's the limit on the number of invoices you can import at a time. Luckily, the way I modelled the data got me around this, so I only needed about four or five imports for the entire dataset initally.

When I wanted to cross-check everything against the original sheets, I couldn't go back more than three months to view payments or invoices. I later found them under "All Transactions," IIRC. I also noticed duplicates, even though QB supposedly prevents them.

Even the API wasn't spared. I eventually used Google Apps Script to automate pushing invoices and payments to QB after transforming the data, while also implementing duplicate prevention and tracking.

One annoying stuff was that the query endpoint requires a POST request with the content type set to "application/text" instead of "application/json". I only found that out after staring at failed requests for a while. Their developer dashboard didnt help either. The save button was hidden off-screen, lol. I only found it after I luckily zoomed out, imagine.

There were a couple of other headaches I'm not even remembering right now. Oh yeah, reconciling payments against individual invoices was another one, especially since each invoice could have multiple payments. It was complicated by the payment structure with inital payments and holdbacks both paid months after date of service.

Anyways, I still found a way through, despite QB's annoyingness. The actual stuff was more complex than this post would explain.

Historical data was successfully migrated and reconciled while also set up so that subsequent data can be transformed to match QB's requirements and imported periodically, covering both invoices and payments. There's also duplicate prevention and a tracking dashboard that flags matches, mismatches, and errors btw sheets and QB.

So, yeah, I finally get the complaints, sort of counterintuitive if that's the right word, luckily didn't have to deal with predatory pricing, another popular complaint I found.

TL;DR: Had issues with QB's user experience while migrating over four years of historical data from Excel to QuickBooks Online. Had to clean and model the data to match QB's requirements without losing the detail it captured, reconcile invoices and payments, and used Apps Script  to automate subsequent imports with duplicate prevention and a dashboard for tracking matches, mismatches, and errors. Pretty much every step was counterintuitive but it worked out.

I've been using the receipt snap feature for a while, since I learned about it, and then later found that could link my bank account directly and pull straight from that. I have been using the mobile app mostly, which is maybe part of my problem. When I jave been doing the reciept snap, it seems the only option is to post it as an expense, or it just goes into the "to be reviewed" folder. I don't see any other option to match it with a bank account or anything, so I've just been posting them.

Now I realized that I am ending up with a lot of duplicate transactions. Is the best course of action to just delete all the receipts, excepting ones that were cash transactions, and then just pull from my checking and credit card statements? Obviously I would still save physical copies of the receipts in my desk, but I just want to make sure I'm not double dipping when figuring out my expenses.

Is there a way to do this automatically, or will I need to manually delete each receipt that was recorded?

Looking for some guidance on this. Our QBO is awful because it's the amalgamation of ten years of multiple people who aren't accounting trained doing whatever they think is best in Quickbooks. I feel like there has to be a "correct" way to handle the multiple locations inventory for a system that's supposed to be as all encompasing as Quickbooks.

I send estimates with a deposit amount selected. QuickBooks has decided that’s the only important number apparently showing it centered and at least 3x larger than the total estimate amount when viewed in an email causing much upfront confusion for people quickly reviewing an estimate.

The total should be the larger number shown and the deposit being second.

I made a free tool for this that is better than the official Intuit connector, happy to hear any feedback: https://starter.meridian.pilot.com/

Im doing anywhere from 30-40 invoices a day. When i open to create a new invoice the date keeps randomly switching to other older dates. Could be a week ago, a month ago, a day before. Its random. It has been doing this weeks now and is driving me insane and creating more work. Ive tried clearing my cache, turning automation off etc.

If someone has the solution to make this stop i will literally pay you $100. I am fed up please help

I set up a new QB account today and spent hours entering information. Now when I try to click on a transaction it gives me this error. I have tried two different browsers, I’ve tried incognito mode, I’ve deleted all my cache and cookies. What else can I try?? This is ridiculous!

EDIT – SOLVED: I created a clearing account called "Owner Bank" in QuickBooks. I used Bank Deposits to move the existing customer payments from Undeposited Funds into this account without recording additional revenue.

I then categorized the owner's deposits in the bank feed as transfers from Owner Bank. For the final deposit, I created a Bank Deposit using the remaining Owner Bank balance and allocated the difference to shareholder contributions.

Finally, I matched that deposit to the corresponding bank transaction. The Owner Bank clearing account now has a $0 balance, all customer payments are accounted for, and no duplicate revenue was recorded. The owner agreed to NOT do this in the future. Thanks to everyone in the comments with the solution here, it worked well!

The owner is depositing cash and checks into his personal account from customer payments, and I'm having a hard time trying to understand how to unscrew the books in QuickBooks from this.

I have several customer invoices where I've noted we've received payments into undeposited funds. However, the owner, in an effort to fix the situation, transferred several deposits for various amounts to make the cash payments/checks cover the outstanding invoices that need cash applied to as a deposit.

For e.g., I have $6k in outstanding undeposited invoices that were paid by customers, but he made 3 transfers that were for some obscure amounts, but they do total roughly to the invoices.

How do I record his 3 varying transfers to match the various amounts needed for the invoices in QB online to show they've been deposited?

Do I need to delete the recorded payments, and then try to match/split them against the deposits?

Thanks in Advance

Has QB desktop been already reverse engineered using REA open source?

Has anyone with zero bookkeeping experience tried out Intuit Academy?
I’ve never done any type of accounting or bookkeeping work in my life. I noticed that the Quickbooks Live Bookkeeper can omit some of the experience required by taking the courses on Intuit Academy.
Can anyone give me an idea of what it’s like to work as a Quickbooks Live Bookkeeper, or if an absolute beginner with no experience have any chance of being hired? Please be kind, life is rough right now. Just found out my remote job of three years is going under and I’m being laid off near Christmas time.

Hey QuickBooks users,

One of the most annoying parts of onboarding new clients or catching up on past-due books is when banks only provide PDF statements instead of direct bank feeds or .QBO files.

I built a lightweight web converter called StatementForge (https://statementforge-ai.netlify.app/) to turn those locked bank PDFs directly into QuickBooks Web Connect (.QBO) and Excel files.

Key highlights:

- Exports natively formatted .QBO files that match QuickBooks import standards

- Runs an automatic balance reconciliation audit before exporting so you don't miss a line

- Privacy-first: Runs client-side in your browser, keeping client bank data confidential

- Free 3 pages/month to test out your statements

Check it out here: https://statementforge-ai.netlify.app/

Hope this saves you some manual data-entry hours, and let me know if there are specific bank formats you want added!

I run a small commercial real estate company; I am a solo syndicator, who outsources all my bookkeeping & accounting. For bookkeeping, I have a setup where I pay for QB Desktop, its setup in a VPN environment, and my outsourced bookkeeper is able to login, do all the work, etc. I pay for a single QB Desktop license that my bookkeeper uses, and it all works great for ~30 company files (one for each LLC, some properties have multiple LLC's) and every year its growing by 3-4 company files as I acquire new properties and create new LLC's.

Migrating to QB Enterprise would run me ~$2k/year, and QB Online would be even worse since I'd need a separate subscription for each company file.

What are other people in my position doing or migrating to? This would be a significant increase in costs from what I've been paying.

Additionally, my current bookkeeper is basically maxed out, and I need to bring on a second person soon. So whatever solution I migrate to would need to be able to have multiple users.

Thx!

Purchased license for QB desktop 2024 for mac a few years ago and a few months back, Intuit forced me to QBO by making my desktop version read-only. I'm a year away from retirement and absolutely despise QBO. Anyone have any idea on how to make my desktop version work again (meaning not read-only)? Gotta be a hack or workaround, right? 🙏🙏🙏🙏🙏 TIA!

One of the reports I like to make is a two-year P&L comparison. I like to make the column as narrow as possible, because all the numbers line up straight, but then it hides the date in the header.

Is there a way to make all of the numbers as lined up as possible while keeping everything visible in the header?

Link to Imgur for a side-by-side example.

Seeking an alternative to QBO with the following features:

* Bill of lading

* True custom invoices (not this fake claim by QBO of their custom invoice feature)

Has anyone else had a problem getting their direct deposit limit increased? And can give me some tips? We made the first request on Sept 30th and some requests afterwards. We have never heard from the Direct Deposit team although a QB support person had me send bank statements on Oct 8. Still crickets. Any advice?

Hey all, I had built a slack notification that sends to execs on a Monday morning and it covered everything from web analytics, Google ad performance and matching against the crm. I also had a connection to quickbooks online e that lasted for only three weeks. It would document weekly revenue, outgoings and new customer information, basically general business direction metrics and it was going well until about two weeks ago. The qbo connector to Claude broke and now it won't connect saying it is not available in the UK. I also went in developer.quickbooks.com and tried to play around different with the app which was how I previously Interacted with qbo using Claude.

Anyone having problems with the connector when an mcp server had worked previously? I have disconnected the official connector and restarted it multiple times but it's not connecting at all.

Here's my situation: I'm still running QuickBooks Desktop Mac 2021 on an M1 Mac Mini with macOS Sonoma. I've avoided upgrading macOS because of compatibility concerns with my unsupported version of QuickBooks, but other applications such as Microsoft Office are now prompting me to update my operating system to macOS 27.

I'm considering switching to Xero, FreshBooks, Zoho Books, or another alternative rather than moving to QuickBooks Online.

Has anyone successfully migrated from QuickBooks Desktop Mac? How difficult was transferring your data and adjusting to the new software? Any recommendations or regrets?

Thanks for any advice!

Helping a friend with their service industry business. He’s taking the business over for his uncle and stuff is in SHAMBLES. I have never seen a file this bad. Total incompetence from their previous “bookkeeping”. They’ve said that they got “screwed over” by accountants in the past, (not returning phone calls, total lag).

Huge negative balances vs what is actually in the bank account. Multiple account balances in quickbooks unsupported and verified.

I have been thinking of just recommending that he starts a new file.

How can this be done? Thanks for the help