Link to home
Start Free TrialLog in
Avatar of icerunner5326
icerunner5326Flag for United States of America

asked on

Export quickbooks check register's memo field

I need to export a list of checks from quickbooks and include the contents of the memo line.  

Obviously the solution should be to go to the account and use quick reports to add the Memo field to the report.  Unfortunately, Quickbooks apparently has two memo fields; the one that shows up on the report is not the one I need.  I need the memo line that actually prints out on the bottom left corner of the check itself.

This field is visible when viewing check register in Quickbooks, but the accountant says it can't be exported.  I find that unlikely.

Any ideas short of using QODBC would be much appriciated.
Avatar of Bill Bach
Bill Bach
Flag of United States of America image

I'm running QBPro2010.

Selected Reports/Banking/Check Detail to open a basic check report.
Clicked Modify Report.  
Scrolled down and enabled the checkbox on Memo. Clicked OK.
The Memo column appeared, which I made wider to be able to see it.
Double-clicked on the check and compared the memo showing in the Memo field on the report with the memo that showed on the check that appears on-screen -- they are the same.  Did a test print of the same check -- this is what prints on the Memo line of the check.  

Please try the same and let me know how your's differs.
Avatar of icerunner5326

ASKER

Thanks Bill, I'll try it out
Ok, sorry for the delay.  The accountant tried it out and here's what she said:

"I tried this and it only shows checks for balance sheet accounts.  It will not show checks on expense accounts.  Why?  I have no idea--doesn't make sense to me.  I've looked at re-setting my features but I don't see anything that will help."

PS We're on QB 2009 Pro.
ASKER CERTIFIED SOLUTION
Avatar of Bill Bach
Bill Bach
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Bill, I appriciate your help.  Not sure why they have two different fields called "memo."