Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowI 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.
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:
I've also added these resources to give you more insights about importing entries and managing bank transactions in 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.
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
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