icerunner5326
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.
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.
ASKER
Thanks Bill, I'll try it out
ASKER
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.
"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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Bill, I appriciate your help. Not sure why they have two different fields called "memo."
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.