Skip to main content
November 14, 2021
Question

Angela_T the answer you provided about uploading checks does not work. There is no Upload Transactions option under Banking and there is no Transactions menu option.

  • November 14, 2021
  • 2 replies
  • 0 views
Please provide steps that actually exist in the current QBO version. Thanks for any help.

2 replies

MJoy_D
November 14, 2021

I can share some additional information with uploading checks in QuickBooks Online (QBO), @sfliquidationtru.

 

If you're viewing QuickBooks Online (QBO) in Business view, you can find the Banking tab as Transactions tab. Check this article: Switch between Business and Accountant view in QuickBooks Online. That will show you how to switch between views and check the difference between the two. 

 

Please take note that you can only upload transactions from a (QBO) format, CSV, or Quicken (QFX) file. Then, review the format of your file. 

 

Follow the steps on how to upload the check transactions:

 

  1. Go to the Banking menu or Transactions menu and click the Banking tab.
  2. Choose the tile for the account you want to upload the transactions into.
  3. Click the Link account drop-down and select Upload from file
  4. On the window that appears, click the Browse button and choose the file that you’ll be downloading. 
  5. Click on Open, then Next.
  6. Follow the onscreen instructions. Match the columns on the file with the banking fields in QuickBooks, then select Next.
  7. Click on Let's go. QuickBooks will now add the transactions to your account.

 

Check this article for more information about downloading and uploading transactions manually: Manually upload transactions into QuickBooks Online.

 

You can now match and categorize those transactions and reconcile them to ensure your books are accurate and there aren't any duplicate transactions:

 

 

If you have other questions about adding your check transactions, I'm happy to answer them for you. Just post it here as a reply and I'll take a look at it. Have a good one!

Fiat Lux - ASIA
November 15, 2021

@sfliquidationtru 

Prepare your Checks data with the following template

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101CheckingJoe's Coffee ######### 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21           
102CheckingCostco ######### PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125           
103CheckingProperty Mgmt Assoc ######### PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000           
103CheckingProperty Mgmt Assoc ######### PO Box 1800   AlbanyNY12345 Mar 2011 RentN  Common Area MaintenanceCommon Area Maintenance100           

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo