How to import Deposits into QuickBooks Online with Business Importer

Bank Deposit

Using Business Importer, you can easily and fast import Deposits into QuickBooks Online.

How to import Deposits into QuickBooks Online: 5 steps

To import Deposits into QuickBooks Online (QBO), please, follow 5 simple steps:
1. Sign in to Business Importer and connect it to QuickBooks.
2. Go to Import tab. Upload your Excel file or paste the DropBox or Google.Drive link. Click on the Next button.

*Important Notes for your Deposit spreadsheets:

Deposit: Account – the name of Bank Account to which deposit is transferred.

CashBack: Account – the name of Credit Card Account.

Deposit: Entity – Name of the Customer or Job.

Txn status – Use these values: Draft, Overdue, Pending, Payable, Paid, Trash, and Unpaid.

Global Tax Calculation – Supported Values: TaxExcluded, TaxInclusive, and NotApplicable. For Non-US only. 

Currency – use international values: USD, AUD, EUR, CAD, etc.

3. Choose the list in your Excel, which contains Deposits you want to import into QuickBooks Online. Click on the Next button.
4. Select Company (you want to import to) and Entity (Deposits), and connect Provider’s labels to Your Labels. Press the Next button.

How to import Deposits into QuickBooks Online

5. Review if the information is entered correctly and click on the Next button.

Your import is in process. Don’t wait until it’s done – you will be notified by e-mail.
See your Bank Deposit import result in your e-mail or in Scheduled import tab.

How-to Guide – How to import Deposits to QuickBooks online

Here is a small How-to guide that will help you to prepare your Excel properly and create correct mapping:

QuickBooks Field Business Importer Name Description Example
TxnDate Deposit date The date entered by the user when this transaction occurred. Default date format is dd-MM-yyyy. You can change it on Settings page. 09/20/2015
PrivateNote Private note User entered, organization-private note about the transaction.
TotalAmt Total amount Indicates the total amount of the transaction. This includes the total of all the charges, allowances, and taxes. 1342.50
DepositToAccountRef Deposit to Account Identifies the asset account to be used for this deposit. Please, provide only its name or number. Checking
DocNumber Reference number Reference number for the transaction. Checking
GlobalTaxCalculation Global Tax Calculation Method in which tax is applied. Allowed values are: TaxExcluded, TaxInclusive, and NotApplicable TaxExcluded
Line.Amount Line: Amount The amount of the line item. 1352.46
Line.LinkedTxn.TxnId Line: Txn ID Transaction Id of the related transaction. 13
Line: Txn type Line: Txn type Transaction type of the related transaction. Values: APCreditCard, ARRefundCreditCard, Bill, BillPaymentCheck, BuildAssembly, CarryOver, CashPurchase, Charge, Check, CreditMemo, Deposit, EFPLiabilityCheck, EFTBillPayment, EFTRefund, Estimate, InventoryAdjustment, InventoryTransfer, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, Purchase, PurchaseOrder, PriorPayment, ReceivePayment, RefundCheck, RefundReceipt, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, TimeActivity, VendorCredit, YTDAdjustment. Bill
Line.Description Line: Description Free form text description of the line item that appears in the printed record.
Line.DepositLineDetail.Entity Deposit: Entity Information about the Customer or Job associated with the deposit. Please, provide only its name. Cool Cars
Line.DepositLineDetail.AccountRef Deposit: Account Name of the account from which the deposit is transferred. Please, provide only its name or number. Automobile
Line.DepositLineDetail.PaymentMethodRef Deposit: Payment method Name of the PaymentMethod for the deposit. Please, provide only its name.
Line.DepositLineDetail.CheckNum Deposit: Check number Check number for the desposit.
Line.DepositLineDetail.TxnType Deposit: Txn type Type of the payment transaction. For information purposes only. Values: APCreditCard, ARRefundCreditCard, Bill, BillPaymentCheck, BuildAssembly, CarryOver, CashPurchase, Charge, Check, CreditMemo, Deposit, EFPLiabilityCheck, EFTBillPayment, EFTRefund, Estimate, InventoryAdjustment, InventoryTransfer, Invoice, ItemReceipt, JournalEntry, LiabilityAdjustment, Paycheck, PayrollLiabilityCheck, Purchase, PurchaseOrder, PriorPayment, ReceivePayment, RefundCheck, RefundReceipt, SalesOrder, SalesReceipt, SalesTaxPaymentCheck, Transfer, TimeActivity, VendorCredit, YTDAdjustment. Bill
TxnStatus Txn status Status of the transaction. Valid values include:
Draft, Overdue, Pending, Payable, Paid, Trash, and Unpaid.
Paid
CashBack CashBack: Account The asset account (bank acount) to be use for this cash back transaction. Please, provide only its name or number. BF Bank
CashBack: Amount Amount of the cash back transaction. 1000.99
CashBack: Memo Memo associated with this cash back transaction.
TxnSource Txn source Used internally to specify originating source of a credit card transaction.
CurrencyRef Currency Values: USD, AUD, EUR, CAD, etc. EUR
ExchangeRate Exchange Rate Specify it in case Transfer is done not in your home currency. Decimal like 1.23 1.7
TransactionLocationType Txn location For France locales, only. The account location. Valid values include: WithinFrance, FranceOverseas,
OutsideFranceWithEU, OutsideEU. Default is WithinFrance.
OutsideEU
DepartmentRef Location Location of the transaction, as defined using location tracking in QuickBooks Online. An identifying
name for the entity instance. This is derived from the instance using the field that holds the common
name of that instance. For example, references for Customer use the DisplayName field to populate this
field.

 

Check out the Deposit import results

There are 5 types of import results.

 import Invoices into QuickBooks Online

Errors in the Deposits import

The most common errors and the ways to solve them.
There are 5 the most common errors made by our clients when they import Deposits into QuickBooks online. To prevent this happening, we have reviewed all of them and given solutions below.

 

Problem Error occurs Solution Correct example
Wrong date format is used. WARNING Error parsing date 01-14-2015: Expected format currently MM/dd/yyyy, but you can change it on your profile page. Change date format to MM/dd/yyyy. 01/14/2015
Wrong accounts for your Bank Deposit Transaction. ERROR Deposit Checking:  Business Validation Error: You can’t use the same account to deposit to and cash back. Please, use the following account types:

For CashBack: Account field – Credit Card account;

For Deposit to Account – Bank account.

Accounts specified:

Balance sheet

Saving234df

Wrong CashBack account. ERROR Deposit Checking: Business Validation Error: The cash back amount must be a balance sheet account.. Please provide for  CashBack: Account field – Credit Card account. Balance sheet

 

Wrong Reference number ERROR Deposit Checking: Invalid account type: You need to select a different type of account for this transaction. Please, provide correct Reference number. 20
Invalid Currency code ERROR Deposit 20: Invalid or Unsupported currency type supplied. Supplied value:US. Specify Currency code (CurrencyRef) . Choose letters according to ISO 4217. For example, USD, EUR, CAD, GBP. USD

 

Remember, that any question you can address us. We will be glad to help you!
Just leave us a message, call us on 302-261-3644 or write to support@cloudbusinessltd.com.

business accounting software 

adodvolha

This entry has 0 replies

Comments open

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>