cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
userannechrissewards
Level 1

Can I upload petty cash transactions from Excel into Quickbooks?

My petty cash data is in Excel. It is too much to type into Quickbooks by hand. I want to upload directly from .xlsx or .csv
2 Comments 2
GebelAlainaM
QuickBooks Team

Can I upload petty cash transactions from Excel into Quickbooks?

Hello there.

 

I'll be sure to help you get your petty cash transactions to QuickBooks Online (QBO).

 

Yes. You can upload petty cash tractions to QuickBooks. Make sure you meet the requirements and follow the format successfully. See this article for details: Common questions about importing data to QuickBooks Online.

 

In QBO, you can import your data through the Gear icon and click Import Data. Otherwise, you can follow the steps below to import your bank transactions to your company file.

 

  1. From the Transactions tab, select Banking.
  2. In the Link account drop-down, select Upload from file.
  3. Click the Drag and drop or select files button.
  4. Select the CSV file and then open it.
  5. From the QuickBooks account drop-down, select the account you want to upload the transactions into.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
  7. Select the transactions, and then click Yes.
  8. Then, click Let's go.

 

Once you get your transactions to QuickBooks, you'll want to match and categorise them. The transactions go into your accounts after you review them.

 

I'm also attaching this article for future reference in reconciling your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.

 

Tag me in the comment below if you have clarification on managing petty cash and other transactions in QuickBooks. I'll always be around to help you.

4Gal
Level 11

Can I upload petty cash transactions from Excel into Quickbooks?

@userannechrissewards 

Prepare your Purchase Cash data with the following template

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClassLocation
101Cash On HandJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21            
102Cash On HandCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125            
103Cash On HandProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000            

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo