Does anyone have an Excel spreadsheet that I can batch enter receipts and then import the data into QBO?

It's good to see you here in the Community, @Al Howe . I'd be happy to provide some information to help you import your receipts to QuickBooks Online.

If the .CSV file contains cleared transactions from your bank, we can import it. With this, it needs to be in a three-column or four-column arrangement. I’ve added some snippet below for your reference:

After that, let’s manually upload your transactions into QuickBooks.

For now, importing your receipts in bulk is unavailable. However, you can utilize one of our third-party applications to batch import transactions. Just visit QuickBooks App Center and select an app that suits your needs.

If the .CSV file you mentioned only contains snaps of the receipts, we’ll need to drag and drop them on the Receipts tab. We can also scan or email them. The supported file formats are PDF, JPEG, JPG, GIF, and PNG images.

Here’s how to upload receipts from your computer or Google Drive:

1. Go to Bookkeeping, select Transactions, then select Receipts.
2. Select Upload from computer or Upload from Google Drive. Please take note that each image or file should only contain a single receipt.

Otherwise, follow these steps if you opt to capture and upload receipts from your mobile device. Before doing so, ensure to install the QBO app for iOS or Android.

1. Open the QuickBooks Online mobile app and click the Menu ≡ icon.
2. Select Receipt snap, then Receipt camera and capture your receipt.
3. Select Use this photo, then Done.

Once done, you’ll need to review or match them. Check out this article and proceed to Step 2 for the detailed steps: Review, add, or match receipts and bills

I'm just one post away if you need a hand with handling your receipts. I'll be here to ensure your success. Keep safe.

@Al Howe 

Do you need to import Sales Receipts data or else?

I appreciate the responses I received. However, they did not provide the complete answer I need. If I only wanted to enter a receipt with a date, a comment, debit and credit, the process would be fine. But I need to enter the date, type of transaction (check number, etc.), vendor, amount, account, and memo. Additionally, in many cases, I need to enter multiple account in a split scenario with each account having an account, amount and memo.

I later found documentation stating that to do what I wanted needed to be importing into QuickBooks Online Plus edition. I am only using QuickBooks Online Simple. I do not need the Plus edition options which would cost me more than three times what I am paying for the Simple edition.

If there is a way to manually enter a split account process, I would appreciate how to do it. I have gone thru many books and manuals, but the only reference I have come across is for 'split view' which is not the split process I am referring to.

Again, thanks for responses.

Al