import excel file into quickbooks desktop

A Customer aggregate refers to one of the customers (or customer jobs) on the list.ĭepending on the request containing it, Item can refer to an item on any Item list such as Item Discount, Item Inventory, and so forth, or it may accept only a subset of item types.įor Bill requests, Item cannot refer to discount items or sales-tax items The customer list includes information about the customers and the individual jobs that are being performed for them. Likewise, if both Quantity and Cost are specified, QuickBooks will use them to calculate the total Amount. If both Quantity and Amount are specified, QuickBooks will use them to calculate Cost. (For example, transactions could be classified according to department, business location, or type of work.) The class tracking is off by default in QuickBooks, so please make sure you have made it on. A Customer aggregate refers to one of the customers (or customer jobs) on the list.Īdditional information about this expense lineĬlasses can be used to separate transactions into meaningful categories. The customer list includes information about the QuickBooks users’ customers and the individual jobs that are being performed for them.

(For example, transactions could be classified according to department, business location, or type of work.) In QuickBooks, class tracking is off by default. The billing status of this item line or expense lineĬlasses can be used to separate transactions into meaningful categories. An AccountRef aggregate refers to one of these accounts. The Account list is the company files list of accounts. The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. In a BillAddress or ShipAddress aggregate, the Note field value is written at the bottom of the address in the form in which it appears, such as the invoice form.Ī string of characters that refers to this transaction. The second line of an address, if needed. (The Account Type of this account will be AccountsPayable.) Refers to an accounts payable account in the QuickBooks file. This field can contain 41 characters maximum. Please, specify only the name of the vendor. Specify the exchange rate, of you can specify only a a currency (in Currency field)if the rate already exists in you company.Ī vendor is any person or company from whom a small business owner buys goods and services. If you want to create the account set the Account autocreation function in our app.A/P Account for the bill should Accounts Payable.ĮxchangeRate with name ‘USD’ not found in your company. Account with name ‘My A/P Account’ not found in your company.Ĭheck the spelling of the account in the file, is should match the name of account in your company. The specified record does not exist in the list. QuickBooks error message: Invalid argument. There is an invalid reference to QuickBooks AP Account “My A/P Account” in the Bill. Specified Account does not exist in your QuickBooks company. Please enter an item.Ĭheck all the Item Names in your file and insert missing ones. QuickBooks error message: You have no items or one or more of your amounts is not associated with an item.

Products are not specified in the file, or specified in a wrong way. You could also enable Vendor auto creation functions to create vendors if they are not found in your company. Make sure the name of your vendor from the file is identical to the one you have in your company, double check extra spaces and spelling. There is an invalid reference to QuickBooks Vendor “RollsMotors” in the Bill. The vendor wasn’t found in your QuickBooks company.

You could also enable Customer auto creation functions to create vendors if they are not found in your company. Make sure the name of your customer from the file is identical to the one you have in your company, double check extra spaces and spelling. There is an invalid reference to QuickBooks Customer “John Doe” in the Bill. The customer wasn’t found in your QuickBooks company.

Import excel file into quickbooks desktop