Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I appreciate the details that you've shared, @jbnichols0709-gm.
I've got some info to share and able you to work with CSV files.
You can enter the bank statement data like the deposits, payments, and expenses in an Excel format and save it as a CSV(comma delimited) file. There are two template formats that QBO supported.
3 Columns
The 3-column template has columns for the Date, a Description of the transaction, and the Amount of the transaction. Where a deposit shows a positive amount, and credit indicates a negative amount.
4 Columns
The 4-column template has a Date column, a Description column, and both a Credit and a Debit column.
These are the columns QuickBooks supported when importing bank transactions.
Here's how you can save it as a CSV file in Excel:
Once done, sign in to QuickBooks and then follow these steps to import the bank data file. Make sure to review the format on the CSV file to prepare for the upload.
You can see the steps and other details through this article: Import bank transactions using Excel CSV Files.
With these steps, you get your missing bank transactions uploaded and able to categorize, match, or add them in QuickBooks. Also, you can add other details from there.
Let me jump in and assist you if there's anything else you need help. I'll answer as fast as I can. Have a safe day!
Utilize trial trial period of TP to import your data in bulk.
https:// transactionpro.grsm.io/qbo
Prepare your data with the following templates
Receive Payments (against your invoices)
RefNumber | TxnDate | PaymentRefNumber | Customer | PaymentMethod | DepositToAccount | InvoiceApplyTo | LineAmount | PrivateNote | Currency | ExchangeRate |
1 | 28/11/2020 | 50245 | Janice Johnson | Check | Checking | 101 | 100,00 | |||
2 | 28/11/2020 | 4908 | Leonard Walker Inc | Check | Checking | 102 | 138,78 | |||
3 | 28/11/2020 | 4908 | Lisa Smith | Check | Checking | 103 | 126,50 |
|
Deposits
RefNumber | TxnDate | PrivateNote | Currency | ExchangeRate | DepositToAccount | Location | Entity | LineDesc | LineAmount | Account | PaymentMethod | PaymentRefNumber | Class | CashBackAccount | CashBackAmount | CashBackMemo |
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 10 | Account1 | Cash | ||||||||
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 20 | Account1 | Check | 12345 | |||||||
1 | 12/12/2020 | USD | Checking | Robert | Deposit | 30 | Account1 | Cash |
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here