- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
check import via import/transactions/checks
I make payments to vendors through online banking. When I attempt to import data from a csv file to the Quickbooks/import/transactions/checks, all the data transfers in with the exception of the check amount. I've tried to paste the data in as a number, as currency and as text. Haven't been able to get it to import, the amount is on the form but when I pull up a check after import, the amounts are always 0.00. I am importing 50 to 60 checks and it is very time consuming to type the amounts in for each check. Not to mention, the possibility of entering in an incorrect amount.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
I appreciate you for sharing your imported checks concern here in the Community, @SRWA.
I'm here to ensure that you'll be able to import the checks successfully so amounts won't show as zero.
When importing transactions in QuickBooks, you'll need to make sure that the mapping of the entries is correct. This way, all the information will show up accurately in the system.
In this case, I'd recommend reviewing the mapping of the amount field from the .CSV file. Here's the complete guide that you can check out for more details about the importing process: Import/export CSV files.
Once verified and the problem continues, I'd recommend reaching out to our Customer Care Team. They have the tools to check your transactions and verify the reason behind this matter.
To contact them:
- Click on Help at the top.
- Select on Contact Us.
- Choose your preferred way to speak with our representatives.
I've also added these resources to give you more insights about importing entries and managing bank transactions in QuickBooks Desktop:
- Learn how to download bank feed transaction to QuickBooks
- Learn how to import or export info with QuickBooks Desktop
Please know that I'm only a post away if you have anything else about importing transactions or with QBDT. Just leave a comment below, and I'll get back to you.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Prepare your Checks data with the following tempplate
| Bank Account | Payee | Transaction Date | RefNumber | Memo | Address Line1 | Address Line2 | Address Line3 | Address Line4 | Address City | Address State | Address PostalCode | Address Country | Vendor Acct No | Expenses Account | Expenses Amount | Expenses Memo | Expenses Class | Expenses Customer | Expenses Billable | Items Item | Items Qty | Items Description | Items Cost | Items Class | Items Customer | Unit of Measure | Items Billable | Currency | Exchange Rate |
| Checking | Sunoco | 01/10/2020 | 100 | Monthly Gas | Sunoco | 1 Main Street | Newtown | NJ | 12345 | USA | Fuel | 25 | John's Car | ||||||||||||||||
| Checking | Sunoco | 01/10/2020 | 100 | Monthly Gas | Sunoco | 1 Main Street | Newtown | NJ | 12345 | USA | Fuel | 50 | Karen's Car | ||||||||||||||||
| Checking | Michael's Fine Cabinetry | 30/09/2020 | 101 | Unitel | 12 Smith Ave | Anywhere | NH | 22222 | USA | Cabinets | 10 | Cabinets | 150 | Baker, Chris:Family Room | Y |
then utilize one of these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2