cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Importing bills to QBO with a credit note

Hi,


The CSV file that I am trying to import has credit notes in it (so they are negatives) and QBO will not let me import these transactions. Would anyone know how I could import credit note transactions?

2 Comments
Highlighted
QuickBooks Team

Importing bills to QBO with a credit note

Hi there, @jhari09. Let me provide you with some information about importing files into QuickBooks Online.

 

QuickBooks Online can import CSV files that use either a 3-column or 4-column format. After the import, you can enter any additional information, such as the Category and Payee for a transaction, on the For Review tab of the Banking page.

 

The 3-column template has columns for the Date, a Description of the transaction, and the Amount of the transaction. 

 

The 4-column template has a Date column, a Description column, and both a Credit and a Debit column.

 

Here's how to import the CSV file:

  1. Go to the Gear icon, then Import Data.
  2. Choose what type of data you're bringing into your account: Bank DataCustomersVendorsChart of AccountsProducts and Services, and Invoices.
  3. Press Browse and select the .CSV file.
  4. Hit Open then Next.
  5. Pick the account from the QuickBooks Account drop-down, then Next.
  6. Input the Date and date format.
  7. Select the Description and Amount statement fields.
  8. When you are ready, click Next.
  9. All transactions in your .CSV file will show. If you'd like to exclude transactions, clear the checkbox next to the date. Hit Next.
  10. Press Yes to import now, then Let's go!

Let me know if this works for you! I'll be here if you need further assistance. Have a safe weekend.

 

Highlighted
Level 13

Importing bills to QBO with a credit note

@jhari09 

You may utilize the importer tool to import (i) the bill and (ii) vendor-credit. The template of the vendor-credit will be as follows

 

RefNumberAPAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples ######### 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office FurnitueNew Chairs300.18           



Need to get in touch?

Contact us