cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
nolan-l-west-gma
Level 1

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

 
Solved
Best answer December 16, 2020

Accepted Solutions
JamesDuanT
Moderator

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

Let's categorise your transactions correctly, 9130 3496 0391 8576.

 

If you have already created the bill in QuickBooks Online, we should Match the expense transaction that was downloaded in the Banking page. If you have accidentally Added it to your register, we can still Undo the process. You can use this link for reference: Unmatch downloaded bank transactions or move them to another account.

 

After that, you can proceed in Matching the bank transaction to the ones in QuickBooks Online. Once you've matched the them correctly, the transaction in QuickBooks Online will be marked as paid automatically.

If you haven't created the transaction to match with it, you can continue Adding it to your register.

 

Here's a link that you can use as your guide regarding the categorisation of your bank transactions: Categorise and match online bank transactions in QuickBooks Online.

 

If you're referring to something more specific, additional details about it would be much appreciated. We'll be right here to further assist you. 

 

 

View solution in original post

4 REPLIES 4
Kristine Mae
Moderator

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

Yes, you can import it in QuickBooks Online, Nolan-l-west-gma. Let me help you.


First, you'll have to create an account where you will add the transactions. This way, you won't be adding it to your bank account. Here's how:

  1. Click Accounting.
  2. Go to the Chart of Accounts tab.
  3. Click New.
  4. Select the Account Type and Detail Type.
  5. Enter the desired name.
  6. Click Save and close.

I suggest reaching out to your tax adviser on what types to use for the account.

 

Next, you can already upload the transactions from Excel.

 

Once done, you can categorise and add bank transactions

 

We're available 24/7. Please feel free to get in touch with us if you have other concerns. Take care!

 

9130 3496 0391 8576
Level 3

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

Hi, I imported expense and assign correct chart of accounts. All the recorded are created as a credit payments and I need to know How can I mark them as already paid?

JamesDuanT
Moderator

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

Let's categorise your transactions correctly, 9130 3496 0391 8576.

 

If you have already created the bill in QuickBooks Online, we should Match the expense transaction that was downloaded in the Banking page. If you have accidentally Added it to your register, we can still Undo the process. You can use this link for reference: Unmatch downloaded bank transactions or move them to another account.

 

After that, you can proceed in Matching the bank transaction to the ones in QuickBooks Online. Once you've matched the them correctly, the transaction in QuickBooks Online will be marked as paid automatically.

If you haven't created the transaction to match with it, you can continue Adding it to your register.

 

Here's a link that you can use as your guide regarding the categorisation of your bank transactions: Categorise and match online bank transactions in QuickBooks Online.

 

If you're referring to something more specific, additional details about it would be much appreciated. We'll be right here to further assist you. 

 

 

Fiat Lux - ASIA
Level 15

Hi, I have a number of expenses that I paid for in cash (ie, not using my bank account), I have them in excel, can I upload them all into QBO, and how would I do it?

@9130 3496 0391 8576 

You may utilize the trial period of an importer tool to import data as Purchase Cash or Bill Payments

https://transactionpro.grsm.io/qbo

 

The templates should be like these

 

Purchase Cash

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            

 

Bill Payments

RefNumberAPAccountVendorTxnDateBank or CC AccountPrivateNoteCurrencyExchangeRateToBePrintedBillApplyToLineAmount
2001 Staples01/11/2020CheckingBill Payment  N101375,53
3454 Green's Taxi Service01/11/2020CheckingBill Payment  N185125,13
321901 Federal Express01/11/2020CheckingBill Payment  N201264,07

 

Need to get in touch?

Contact us