Inventory Reporting and Best Practices in MarginEdge

 

When Should I do Inventory?

A full inventory is typically done on the last day of each accounting period and should be taken after the close of business. 

To ensure your inventory matches your sales data it is essential that the dates are set correctly.

When entering new counts into MarginEdge, you will be prompted to enter a date: The date you enter represents the last day of business that will be included in your inventory. Remember: it does not matter what date you enter the data, ALWAYs use the date the inventory was physically counted.

Your ending inventories taken on the last day of the period/month will automatically be used as the starting inventories for the following period/month. Reports in MarginEdge will reflect a one day offset from the date the inventory was taken. 

What to Include in Inventory

It is imperative that what is being counted is consistent each time you take inventory. When comparing any two inventories any Product counted on either inventory but not accounted for in the other, will be reported as having a count of zero on the date when it was not inventoried. Because of this, when comparing inventories, it is essential to compare apples to apples: Compare spot inventories to spot inventories and full inventories to full inventories.

Spot inventories are helpful for tracking key items over the short term; however, the only inventories that can be posted to accounting are the end-of-period inventories.

When an inventory is closed, it becomes eligible to be posted to accounting as an inventory adjustment journal entry. It must be reviewed by someone who holds Manager or Restaurant Admin status for your restaurant in MarginEdge before it can be posted. Important! Once it has been posted, it can no longer be modified in MarginEdge.

Mapping Your Inventory Accounts

Before you can post your inventory to accounting in MarginEdge, there’s one last step. You’ll have to map your inventory accounts, so we know which accounts to post inventory adjustments to in your accounting system.

Go to Accounting > Categories. On this screen, you will see your categories in MarginEdge and how they’ve been mapped to your chart of accounts. To the right of the “Accounting System Account” line you will see a column titled “Inventory accounts’. If you double click this field a drop-down menu will appear, allowing you to select the inventory account corresponding with the account in the “accounting system account” column.

 

Vendor_Account_Mapping_Pic.png

Posting Inventory to Accounting in MarginEdge

When you post inventory to accounting in MarginEdge, we do not post the full value of your inventory; what we post is an inventory adjustment entry, which is a journal entry that records the difference between the value of your last posted inventory and the value of your current inventory.

Inventory Adjustments posted to accounting will be sent as journal entries that affect the expense and inventory asset categories mapped as shown above on the Accounting >  Categories page as seen above. See an example inventory adjustment entry below.

Posting_to_Accounting.png

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.