We just have added the ability to import deposits into QuickBooks Online. This feature is only available in the latest release of Transaction Pro Importer (“TPI”) which is currently in beta and is being offered to a small subset of our users. However if you would like to have access to this latest version of TPI just send us an email to email@example.com asking for access to this latest version along with your QuickBooks Online company id (which can be found under the gear in QuickBooks Online under the Your Account section).
Below is a screen shot and table showing all the QuickBooks fields as listed in our TPI application and the QuickBooks Online field on the deposit transaction in QuickBooks Online.
|QuickBooks Field||QuickBooks Form - Field Description||Notes||Required Field||Type (D for Date, N for Number and T for Text)|
|RefNumber||Only used for TPI internal grouping purposes.||This field is how TPI knows how to group multiple lines onto the same sales receipt. If you would like to let QuickBooks auto assign the next invoice number select the TPI ipion to Let QuickBooks Auto-Assign Invoice Numbers. TPI still needs a RefNumber for internal grouping even if you enable this option.||Y||T|
|TxnDate||Deposit - Date||D|
|PrivateNote||Deposit - Memo||T|
|Currency||Deposit - Currency||T
|ExchangeRate||Deposit - ExhangeRate||N
|DepositToAccount||Deposit - Chose an Account||If using account names include the account and the sub account separated by a colon (eg Checking:Wells Fargo). If using account numbers turn on the option to enable account numbers in TPI.||Y||T|
|Entity||Deposit - Received From||If using jobs include customer:job in this column||T|
|LineDesc||Deposit - Description||T|
|LineAmount||Deposit - Amount||T|
|Account||Deposit - Account||If using account names include the account and the sub account separated by a colon (eg Donations:WinterProgram). If using account numbers turn on the option to enable account numbers in TPI.||T|
|PaymentMethod||Deposit - PaymentMethod||T|
|PaymentRefNumber||Deposit - Ref Num||T|
|CashBackAccount||Deposit - Cash Back Account||If using account names include the account and the sub account separated by a colon (eg Checking:Wells Fargo). If using account numbers turn on the option to enable account numbers in TPI.||T|
|CashBackAmount||Deposit - Cash Back Amount||The total amount of the cash back amount on the entire deposits needs to be repeated on each line.||N|
|CashBackMemo||Deposit - Cash Back Memo||T|
If you have any comments or questions feel free to post a comment below.