Exporting Daily Z-reports from MRS to Quickbooks

Jul 24, 2006 7 Replies

Hello all,



Basicly im trying to figure out how to export the daily Z-reports from Microsoft Retail Systems 1.2 to Quickbooks (I believe 2005) in 3 steps or fewer. Ideally, there should be a way to do this without exporting the data to a file, but rather do it directly from MRS after posting the z-report.



If anyone can help please let me know


if you are using the US version of Quickbooks, the ability to post directly from RMS to QB is built in - you just need to set it up and assign your accounts. Ask your RMS reseller and Accountant/Bookkeeper for help - usually takes about 2 hours to get it right.

If you are not using the US version of QB, you will have to export to a quickboosk file, then open QB to import it. The account mapping is is the same though...

Glenn Adams Tiber Creek C> Hello all,

Hello and thanks for the GREAT information to help me set this up. Is it possible you can email and tell me a few steps to get started?

Would the ability be built > if you are using the US version of Quickbooks, the ability to post

would you also email the information to me?

Thanks, Bill

"R.Delgado06" wrote:

I did try mapping the accounts, no success after days. Quickbooks still gives me an error. The Accounts are not in balance. I showed it to my accountant, and she gave me the OK, go ahead and try it this way.. Nothing..

Can someone post an example of mapping the accounts correctly?

Thanks

"zoostati> sorry, my email address is snipped-for-privacy@comcast.net >

Did anyone ever get an answer on this?

Jamie

"JuanSe" wrote:

You need to make sure all of the pluses and minuses add up in the .iif file (for each batch). If they all add up, then you are missing or have a bad account number. Do a simple export with just one batch and look into the .iif file with Notepad. You should be able to sort out the issue.

Just a side note: Don't use Quickbooks Online Edition. They don't support importing .iif files. I learned the hard way after transferring my whole acounting over to QBOE.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required