If MarginEdge doesn’t integrate with your POS system or if you would like to enter sales that were not rung up in your POS system, you can manually enter sales entries in MarginEdge in only a few minutes.
Setup - Create your Sales Mappings
Log into MarginEdge and go to Accounting > Sales Mapping. You’ll see the screen below.
Note: This screen is only editable for users with the Franchisee Accountant, Accountant, and MarginEdge Admin role.
To create your Sales Mappings, click the + Add Row button. You should then see a new row in the table.
Next, start typing in your sales mapping details. Below is a description of each column:
- Description is the name of the entry
- Accounting System Account are the accounts from your chart of accounts. By double-clicking this field, you can select an accounting code from your chart of accounts, and this will allow your sales entries to flow over to your accounting system because MarginEdge has instructions on where to send that data. You can have multiple rows report to the same accounting system account. Everyone has their accounting set up differently. If you do not know how these POS items should be coded/mapped, you may need to contact your accountant regarding the best way to record this information.
- Category Type will either be blank or “Food, Beer, Wine, Liquor, NA Bev, Retail or Other.” For the rows related to sales of one of these types, please pull down the menu and select the relevant type.
(Note: this information is not actually for the accounting export. It is used in MarginEdge for your P&L, food usage, and budgets, etc...so the items you flag as “Food” will count in the appropriate places). If you wish your discounts to be reported show in your net sales in MarginEdge, you will need to select a category type. If you do not wish a discount to appear in your sales reporting in MarginEdge, do not select a category type.
- Include in Sales Reporting: This does NOT exclude this line from reporting to your accounting system! This field determines what is included/excluded in your sales calculations. How this is set in your sales mapping page will determine what you see on P&L, home screen Sales Report, sales emails, etc.... Select include for any line you wish to include, select exclude for any line you want to exclude. Anything set to “Exclude” does not require a Category Type.
- Memo: This line is for your notes (optional). They will appear in the memo field in your accounting system if memos are supported.
- Accounting System Accruals: This optional field allows you to accrue assets or liabilities if the line’s Accounting System Account you mapped requires a vendor or a customer.
- For example, if you want to accrue sales tax to a vendor (“State XYZ Treasurer”), you can choose the correct AP account in “Accounting System Account” and then choose the Vendor here. Or, if you want to accrue a receivable, you can choose the AR account in “Accounting System Account” and the customer using this field. This is rarely used but will need to be mapped on this screen if you would like it to use it.
- Class: You will see this column if you use Classes or Locations in QuickBooks. If you don't see it, no worries! If you do, you will need to set the appropriate class for this unit. This is done in the sales mapping screen. By double-clicking this field, you can select the appropriate class or location from your QuickBooks.
- Group: This allows you to report separate rows from your POS together. For example, your POS has separate rows for Visa, Mastercard, Discover, and American Express, but you likely don’t want the accounting entry to show these separately because they come in as one deposit. If you put the same Group number on multiple rows, we will combine them and send them across as a single amount.
- You can have an unlimited number of groups (or none): just start with a "1" for the first group, use a "2" if you have another group, and so on.
Once you have completed filling in the details for your sales mapping line, repeat this step for all sales mappings you want to appear in your sales entry and then click Save Changes. When you hit Save Changes, your sales lines may look like they have disappeared. If you change the View By filter to “Show All”, you will see your newly created sales mappings.
Once you have set up all of your sales mappings, you will be able to manually record your sales in MarginEdge.
To enter sales manually in MarginEdge go to Accounting > Sales Entries. Select “Record Sales.”
Enter the date of the sales (this date should represent the day of the sales, not the date you are entering the information). If you are entering sales on a weekly or other period, we suggest entering dates at consistent intervals, but you can only have up to one entry per day.
Enter the total amount for each category. If there are categories that have no credits or debits to report they can just be skipped.
When you have finished entering your sales, press save to record the information.
Note: Sales entries must be balanced to be saved. If your total debits do not equal your total debits you will not be able to save your sales entry.
Can I manually add PMIX data into MarginEdge?
Unfortunately, no. You can add sales lines manually as described above, but you cannot manually input Product Mix data to MarginEdge.