The Neat Company Forums

UPDATE!!!!

To all who have written about the NR2Quicken Excel file, I have updated the file to now port the information from the NeatReceipts output DIRECTLY into the Quicken accounts.  It works with Quicken 2007 and newer, and it was made in Office 2003, so I cannot guarantee compatibility with older versions, if you try it and it has problems, let me know...

This template will generate a QIF file that:

1. Keeps split receipts under a common transaction in quicken, and lists the categories under the "split" instead.
2. Transfer the contents of the "Payment Type" column (or whichever column you choose to map) to the Memo field in Quicken. It also then sets up the QIF file to put the info STRAIGHT into the quicken account, without the need to use a dummy account as before.
   

Setup and use instructions are located at the "Instructions" tab in the file.

An additional change in this recent version is that it automatically (if you want) will add a split line in Quicken for your sales tax as recorded by NeatReceipts. 

Hope it is helpful, if anyone has any questions/suggestions, please drop me a line. Now I just have to figure out how to attach it to this message......

Scoobydeux 

This needed some attention.  To the top of the pile you go!

I'm quite impressed.  I've had one of my guys playing with this, and we're very happy with what you accomplished here.  You even commented the macro code.

One bit of feedback/bug report - it seems that this represents 'standard' transactions exported from NeatReceipts as income in Quicken, rather than expenditures.  Was that intentional?

 

---

Mike Landis
The Neat Company

Hi Mike. Dangit, you beat me to it, I caught that bug and updated the xls file the next day, thought hopefully noone had downloaded it yet.  The current one works.

I have been using this now for 2 weeks, and it has worked well for me. If it makes the next 2.7.6 revision, I'll happily throw it away though... :)

Scoobydeux 

Thanks for the great work and I'm with you on seeing MEMOs and your other features included in  the next upgrade. 

 

Billy 

Thanks for all you help...you've made my life with NR and Quicken much easier! 

 Does anyone by chance know if the new version of NR will have a better interface to connect with quicken?

H jgm,
Version 2.8 and 3.0 have the same interface and interaction with Quicken.  We are currently exploring ways to improve the export to Quicken so it's easier for users.

 

Sincerely,
Jenn 

Could someone please repost this template file.  I get an "Access Denied" error when attempting to download from the URL posted above. Thanks.

boomboom21:

Could someone please repost this template file.  I get an "Access Denied" error when attempting to download from the URL posted above. Thanks.

Here you go.

- Les

Has anyone gotten the this template to work with Excel 2007?  I get the following error:

"The following features cannot be saved in macro-free workbooks: VB Project.  To save a file with these features, click No, and choose a macro-enabled file type in the file type list.  To continue saving as a macro-free workbook, click yes."

I think this may be because Excel 2007 has new file types for macro enabled workbooks.  (xltm, xlsm, etc).  NR will only let you choose xlt and xls.

Any suggestions? 

 

I also cannot export to Excel 2007.  The data map works well but the receipts don't export right.  They stack on top of each other and don't align with their reference numbers.  Business are moving to Office 2007 and Neat Receipts needs to step up!

Jenn...

 Does NR support exports to .xltm yet? I have a few friends who want to buy a NR, but they use Office 2007 and don't want to buy unless the NR2Quicken will function correctly, so they can export to Quicken quickly....  (Plus I am about to switch to 2007 myself, but not until I know NR will export to the .xltm extension....?)

 Thanks.

 Scoobydeux

This post should be marked permanent or something along those lines. It took me an hour or so to find it again and it solves some of the issues with Quicken NeatReciepts exporting with split transactions.

Scoobydeux:

Jenn...

 Does NR support exports to .xltm yet? I have a few friends who want to buy a NR, but they use Office 2007 and don't want to buy unless the NR2Quicken will function correctly, so they can export to Quicken quickly....  (Plus I am about to switch to 2007 myself, but not until I know NR will export to the .xltm extension....?)

 Thanks.

 Scoobydeux

 

I don't see where Jenn ever answered this post from almost a year ago...I just upgraded from NR 3 to 4 and from Office 03 to 07...is there hope to export via excel and input into quicken as I used to using the scooby script?

Jenn?  Any luck adding the coding to allow export to ".xltm" for Office 2007?  Really holding a lot of users back.... Including me.  I now have one machine with office '03 purely because of your program, and that is the one I have to keep NR on....  Very inconvenient to me and others here....

Thanks!

 

 Scoobydeux