Export to QuickBooks

How to set up Folder Labels, Types and Names for QB.

USMCSGT323 — Sun, 01 Nov 2009 04:36:51 GMT

I am an accountant and I because I would like to like to be able to import the data into multiple companies I want to make sure all of the labels, names, and types are properly organized prior to entry of of the receipts. I have set up the following:

Folder TYPES = Each of the companies.

Folder LABELS = Account Type - E.G. expense, fixed asset, loan to another company.

Folder NAME = Quickbook expense, fixed asset, loan NAME. (E.G. Office supplies, automobile. other)

Would something like this export into QB ok?

Also if the software picks up the debit card number and automatically books it to the appropriate FOLDER TYPE (COMPANY) will this still export ok?

Thanks for any help you can provide.

Export to QB works, but creates wrong transaction type

KenCollier — Wed, 14 Oct 2009 19:14:23 GMT

I just got my NeatReceipts scanner, and am a fairly seasoned QB user. I've read the complaints about the Neat QB export utility and my experience with the latest version is somewhat better than others have reported. However, I'm currently stuck on this and hoping someone will offer some suggestions. Here's the sitch:

I'm using QB Pro 2007 on Windows XP Pro and I am logged in as an admin user. I have scanned several AmEx credit card receipts and am exporting them using the QB Direct method. The export wizard properly enables me to map expense categories and expense accounts (in this case AmEx). The problem is that after the export is complete, the transaction appears as a BILL PAYMENT type in the QB account register rather than a CREDIT CARD CHARGE type. It is important that the transaction be of a CREDIT CARD CHARGE type so that I can assign it to an invoice for reimbursement. Unfortunately there is no way in QB to convert a BILL PAYMENT transaction into any other transaction type, so I'm stuck!

Does anyone know how I can force the Neat QB export to produce the correct transaction type?

Cannot export to Quickbooks

Danielca2 — Thu, 04 Jun 2009 23:20:52 GMT

Has anyone been successful with directly exporting to QB? The instructions say to have my QB company file open but then tells me I need to close it. When I do it cannot connect. Tech help took control of my computer and could not solve it either.

Thanks, Dan

Export from Neat to Quickbooks

ashley17 — Fri, 25 Sep 2009 05:48:45 GMT

I just bought neat was so happy that receipts could put export to Quickbooks (SO I THOUGHT). But I've been trying for 2 hours to figure it out, and nothing. What a waste for money. I now have to enter it twice once in QB and now neat just to have a copy of it to reduce my paperwork. Please address this issue. It think that NEAT is very misleading. Please e-mail me at ashleybarclay17@yahoo.com i would love to hear what you think or if you would like to help me get it working.

Ashley

Export to QuickBooks does not balance.

drayvar — Mon, 15 Jun 2009 22:55:18 GMT

I'm having a problem where I will put in the total / GST / PST in a receipt; when I export to QuickBooks and open the associated record, the total value would be changed to reflect the 5% GST instead of the amount that was on the receipt. Has anyone encountered this, have a solution to fix this?

NeatReceipts cannot open my QuickBooks file

Deebr — Tue, 04 Nov 2008 22:36:45 GMT

I am trying to export directly into my QuickBooks2007 file and NeatReceipts keeps telling me it cannot open the file. I thought it might be my password so I removed it but it has not helped. I am not sure what to do. I prefer to use the direct export feature rather than the .IIF file as it will be much easier to align my accounts. The extra work is not worth it.

Any suggestions?

NeatWorks & QuickBooks

Jenn — Fri, 10 Oct 2008 15:54:33 GMT

General Overview
NeatWorks software exports transactions to Quickbooks as General Journal entries. During the export process, the user must select a debit account and a credit account from their Quickbooks Chart of Accounts. The debit account can be thought of as being analogous to the NeatWorks "Category" column, while the credit account is similar to "Payment Type." The selected values will be applied to all transactions currently being exported. NeatWorks will not make entries in the Checks or Bills area of Quickbooks.

Types of Quickbooks Export
NeatWorks has two separate export routines for Quickbooks. The 'Direct to Quickbooks' method will attempt to connect to the Quickbooks data file on your PC directly and write transactions there in one step. In order to do this, Quickbooks must be open and running on the same PC. The 'IIF' export can be used to add transactions to a Quickbooks instance on a different PC.

General Export Tips
Since the same credit and debit accounts are applied to all transactions within the export, you may wish to export in batches of 'like' transactions. You can sort transactions in NeatWorks by category by clicking on the "Category" column, which will group transactions by category. Use the Shift key to select all of the transactions with the same category that you'd like to export, then use the 'Selected Receipts' option in the export dialog, rather than the 'Entire Folder' option. You may also wish to consider using one of the checkmark columns in NeatWorks to mark receipts that have already been exported (or need to be exported) to avoid exporting the same receipts twice.