Exporting Daily Z-reports from MRS to Quickbooks

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

Reply to
R.Delgado06
Loading thread data ...

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,

Reply to
Glenn Adams [MVP - Retail Mgmt]

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

Reply to
R.Delgado06

would you also email the information to me?

Thanks, Bill

"R.Delgado06" wrote:

Reply to
zoostation

Reply to
zoostation

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 >

Reply to
JuanSe

Did anyone ever get an answer on this?

Jamie

"JuanSe" wrote:

Reply to
Jamie Boucher

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.

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.