The default settings in MarginEdge only allow end end-of-period inventories to be posted. Under this configuration, you can still take spot inventories for tracking key items over the short term, but cannot post them.
However, if you want to be able to post inventory weekly, please reach out to help@marginedge.com so we can adjust your settings. Once enabled, the postings must be 7 days apart each time. And if you are part-of a multi-unit company, this will apply to all locations in your company.
Article Contents
- Consistency is Critical
- Entering the Correct Inventory Date
- Posting Inventory = Posting Adjustments
- Mapping Your Inventory Accounts
- Ready to Post!
- Export Settings
Consistency is Critical
It is imperative that what is being counted is consistent each time you take inventory. Creating and using the appropriate [me] Count Sheets will allow you to keep full inventory counts separate from any mid-period spot counts you might do. If a Product is counted on one inventory but not accounted for in the other, it 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; meaning, compare spot inventories to spot inventories and full inventories to full 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.
Entering the Correct Inventory Date
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, the date you enter will represent the last day of business that will be included in your inventory.
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.
Posting Inventory = Posting Adjustments
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 on the Accounting > Categories page.
See an example inventory adjustment entry:
Specifically, any increase in the value of your inventory between the previous (starting) inventory and the current (ending) inventory for a particular category will be logged as a debit to that category’s inventory account and a credit to that category’s COGS account.
The opposite is also true: if there is a decrease in the value of your inventory for a particular category, it will be recorded as a credit to that category’s inventory (asset) account and a debit to that category’s COGS account.
In the example above, the difference between the inventories’ value for beverages was $662.29. The journal entry would go to your accounting recording a debit of $662.29 to the beverages inventory account and a credit of $662.29 to the beverages COGS account.
Conversely, the difference in the inventories’ value for misc. food was -$24.27. The inventory adjustment journal entry would go to your accounting recording a credit of $24.27 to the misc. food/food-other inventory account and a debit of $24.27 to the misc. food/food-other COGS account.
Inventory adjustments will appear in your budgets and can be viewed in detail under the Accounting> Inventory entries.
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 are mapped to your chart of accounts. In the very last column, you will see a “Inventory Account". If you double click this field, a drop-down menu will appear, allowing you to select the inventory account corresponding with the correct Accounting System account.
If you have two or more categories with the same Accounting System Account, those cannot have different Inventory Accounts mapped. When you try to post, an error will pop up and you will need to fix the categories in order to proceed.
Ready to Post!
To post an Inventory Adjustment to accounting, go Inventory > Inventory Summary and select the Starting Inventory and Ending Inventory.
- We are not posting inventories but inventory adjustments to your accounting system, so you need to have TWO inventories in MarginEdge to post an adjustment
- Only adjustments between end-of-period inventories can be posted to accounting (unless you have requested a change in settings for your unit)
Because we use the ending inventory of the previous period as the starting inventory value of the current period, the dates of the starting inventory as seen on this screen will be one day after the date that/those inventory dates were counted. (so in the example pictured below, this restaurant took their inventory on the last day of their previous period [8/2] but it appears with the next day[8/3] as it is acting for these purposes as the starting inventory value of their next period).
Once you have selected a starting inventory and ending inventory, you can post the adjustment by pressing the "Post to Accounting" button. This will create the journal entry and make it available for export on the Accounting > Export screen alongside invoices and sales entries.
Export Settings
Your inventory entries can be set to export manually, or automatically by going to the Setup > Integrations page and clicking on "Edit Configurations" next to the name of your accounting system.
Once here, you can set choose your desired settings. Remember, you always control when to actually post it from the Inventory Summary page; this accounting setting controls whether the actual export to your accounting system is automatic or manual each time.
If you are using Classes for your Inventories, you can set those here as well.