Question

Split transactions in Receipts tool

Forum|Forum|6 years ago
December 17, 2019
2 replies
7 views

I had previously used Autoentry to capture receipts for syncing with Quickbooks, but was happy to learn of the new Receipt Capture tools in QBO. I switched over to using that tool, and am now going through and verifying/entering receipts as expenses. However, there seem to be a few limitations - am I missing something?

First, I see no way to split transactions into multiple expense categories. I have several vendors that sell a range of products that do not all fall in the same category. This is easy to do when entering regular expense, but it doesn't seem possible in the Receipt tool.

Second, while it does a good job of capturing the amount and date of the receipt, I'm surprised it doesn't capture the Vendor, and learn accounts for those vendors. I have to manually select a vendor. category, and bank account for each receipt, which is something Autoentry does automatically.

Third, after saving the receipt details, it searches for potential matches, but never finds any, even though all of these expenses have been imported into my bank account feed. I suspect when I go to banking, these transactions will show a match with this receipt entry, but it seems the tools is supposed to allow for this matching and accepting right away when inputting a receipt detail. Is this just a glitch?

The lack of splitting functionality is the biggest issue for me, but the other features I mentioned would make the process more efficient and on par with other receipt apps out there.

Thank you,

Dana

QuickBooks Online

JasroV

Level 8

I appreciate you for sharing the details of your concern, @sognvalleyfarm.

In uploading receipts in QuickBooks Online (QBO), you can only choose one expense account. However, you can split them when added in the For Review tab.

Here's an article you can read for the details (read Splits transactions between multiple accounts section): Download, Match, and Categorize your Bank Transactions in QuickBooks Online.

To answer your second question. You'll want to create a separate expense account for each vendor. This way, you can tag multiple vendors when creating an expenses or check.

Then for your third question, make sure to add the imported receipts as an expense and select the right bank account. This way, it'll find a match on the Banking page. Also, review the receipts if they have the same amount in the For Review tab.

You can also check this article for additional reference on how to manage imported receipts in QBO: Manage your Receipts in the Receipts tab.

Once done, you can now assign and categorize the transactions. I also suggest contacting your accountant for further assistance in recording this. This way, you'll be guided accordingly.

Please contact us anytime you have other concerns with your QBO. I'm always here to help.

S

sognvalleyfarmAuthor

Thank you very much for the reply. I know I can split expense transactions into multiple categories in the For Review tab within Banking, but is there a way I can connect those transactions with the Receipt capture? It seems that the receipt expense only because able to be matched after an expense is created in the Receipts tab. But in order to do that, I have to put it through with just a single category.

Since the digital receipt capture is my only record of these receipts, and I want them attached to the expense transaction, do you know of a way I can use those receipts but still split into multiple accounts?

MaryLurleenM

Level 6

Hello there, sognvalleyfarm,

You can instead save this digital receipt as an attachment so you can add it on multiple accounts.

Attachments in QuickBooks Online lets you attach these to customer and vendor profiles. You can also add attachments on the transactions. You can learn more about that here: Attachments in QuickBooks Online.

You can upload attachments without adding them to transactions. Here's how:

Click the Gear icon.
Select Attachments under Lists.
Click the Attachments link, browse your computer for saved data.

Stay in touch with me if there's anything else I can be of help.

L

Lsaccounting

Attention QuickBooks Team:

I don't think you're understanding everyone's "gripe" here. I am also having the same problems.

We all understand how to upload receipts. We all understand how to use the banking page.

The problem isn't with these actions. The problem is with the Receipts Page.

As of today, there is only 1 expense category to chose from for each receipt. However, in reality, all of my clients purchase items on a single receipt that need to be split into multiple categories. So uploading receipts into the ReceiptTool is not convenient. You're telling your customers to upload the receipt, pick 1 category, and then to go back into that transaction, reopen the receipt in another tab and then split the transaction there? YIKES!!! Talk about wasting time and money. Not efficient.

I currently use ReceiptBank for all of my clients and have tested the ReceiptTool for QBO and am extremely disappointed that you are not taking into account the reality of receipts and split transactions. The worst part is, you are not listening to everyone's question here and just giving them generic links to click to about other pages on your site. I don't think you're actually hearing us.

I suggest you take a look into the ReceiptBank tool and how that software works. This would be a great way to learn what we are taking about and how to revamp this service on your page. You might actually have more people using it and signing up for it. As of right now, I will not be suggesting my clients to make the switch over. It's just too time consuming and I'll actually be losing money due to lost time by having the receipts uploaded here rather than ReceiptBank.

Please listen and learn what we need.

Thank you.

B

Budget Friendly Bookkeeping

I'm sorry to say, you're message to the QBO Team basically falls on deaf ears. Well not necessarily deaf, but more of "a none policy" care...This is just one and only one "BOOKKEEPING" issue that has been brought to light to the QBO team with only canned responses. It is unfortunate that Intuit has lost its way. What was once a strong and solid bookkeeping system that started out being ridiculed by the accounting professionals of the world, was soon, not only praised by them, but many needed bookkeepers to help teach it to them, lol. Heck, I was one of the first to graduate college using QBD to get through all my college take home exams. The professors were absolutely baffled and had no choice but to accept it as perfect. Okay, so, yes, I'm old, but I've seen QBD grow into what was probably the best thing to come along since the abacus ;)...
So now we're faced with dealing with all the inefficiencies of this tool. Unfortunately, once you export your data and start your daily routine, over time you begin to realize this tool may not be the tool for you. By then, it's too late and you cannot export your data back to QBD. This of course was done deliberately for perpetual income for the intuit money making machine. Your only option is to export your reports and enter your balances into QBD or another accounting software. But many just end up falling victim into purchasing all of the $4.95 options for all of the APPS to do this or that that the QBO version is missing (conveniently).

Eh - I can go on and on... I wasted enough time on this only because I'm tired of wasting time on the books - LOL... But I gotta get back to wasting more time. Hey, don't get me totally wrong here. I have managed to set up one particular client to automatically download and categorize. The trick is, you need to change how they run their "business" to match the "accounting system", not run the "accounting system" the way the "business" runs LOL...

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded