3 replies to this topic

[RonPatla]

Hi,

I'm a new MOM user running version 5.3. I'm in the process of switching our sales department over to MOM from Peachtree Accounting. We have about 170 primary products and we'd like to be able to post sales, cost of goods and returns to the Peachtree General Ledger by product.

By default, it appears that MOM only lumps the transactions (sales, cost of goods, etc.) when the post A/R journal function is run. However, the manual says (page 127) I can set up sub-accounts for individual product sales. I've experimented with the demo version and see that the sub-account codes are two-digit alpha/numeric that would allow for up to 1,036 sub-accounts.

Before I spend the time setting up all the sub-accounts, I thought I�d ask if anyone uses this method for tracking data by product in MOM for transfer into an accounting program like Peachtree. If so, how is it working for you?

Thanks,
Ron Patla
RIVCO Products

[john]

the G/L posting transfers accounting numbers only. you are tracking product or service sales (quantity, price, margins) in MOM. when you post (at the end of the month for example,) just the accounting balances come over.

we use departments to separate product-line sales as well as from billed shipping revenue (which MOM definitely needs to fix). it works pretty well. When we want to see how many widgets we sold over the past year - that is a MOM report (or R&R.)

We use QB. I have heard Quickbooks works better than Peachtree for integration with MOM. MOM creates the *.iif files to import into QB - it works like a champ.

Hope that helps.
John

[RonPatla]

Thanks John. I think that's what I want to do with departments for each product. I'd like to transfer over to Peachtree, sales accounting data broken down by product (in other words showing the sales revenue by product).

Reports such as the Profit by Product report do a decent job of showing units sold, gross sales, gross profit, etc. However, our accountant has asked whether we can bring over the sales accounting data into Peachtree broken down by product. It looks like we can do that by setting up departments (sub-Accounts) under maintain GL.

Could you please expand on your comment "we use departments to separate product-line sales as well as from billed shipping revenue (which MOM definitely needs to fix)." I don't understand the part about billed shipping revenue and what MOM needs to fix.

I appreciate the help!
Ron

[john]

there is not a separate G/L account for shipping revenue. when you invoice for shipping, it simply ends up the "sales" G/L line along with all other merchandise revenue. while there is a place in MOM to analyze your shipping revenues and the attendant costs, it is better to separate out those from your product sales. A lot of DM companies actually net billed shipping and freight out together in COGS. Better for tracking material margins, etc.

To avoid this situation, you create product revenue accounts in the "departments." then, shipping revenue is the sole revenue in sales.

I would have just made shipping revenue go to it own G/L account if i designed the system.