Taxes, delivery fees, fuel charges, and other miscellaneous fees are not entered like regular line items in MarginEdge and you have control over how they are booked and categorized.
If you look at any invoice uploaded to MarginEdge by going to the Orders page, you'll see under the line items are a series of fields where your miscellaneous charges are entered:
So what happens when values are entered here? By default, these charges are booked proportionately to all expense categories found on the invoice.
So, using the export from the Category Report, you can see that the misc charges above ($4.77 in Taxes and $4.70 in Delivery fees) are booked to the Food Categories of Other, Diary, Seafood, Beverages, and also to Restaurant Supplies.
Note: While these charges are booked to the categories on the invoice, they do not affect the product price in any way, only the category total.
How can I code my miscellaneous charges to a single Category?
These settings can be configured independently, on a vendor-by-vendor basis (and keep going to next section to learn how to do it for your entire unit).
Go to the Vendors Menu, select the vendor you'd like to configure, and click the "Edit Vendor" button:
Once in the vendor, scroll down to the Accounting Configuration section and check the "Configure how to handle Miscellaneous Charges" checkbox:
For this example, we will map Delivery / Shipping / Freight / Fuel misc charges to the Category "Delivery Fees" but leave the other miscellaneous charges set to the default
So, using the export from the Category Report, you can see that the taxes on the invoices are still being distributed proportionally, but the delivery charges above are booked now to just the delivery fees category.
How can I set these rules for ALL my vendors at one time?
If you would like to change the rules for all your vendors at once, you can do so by going to the Vendors menu and clicking the Configure Defaults button:
Here you will see the same basic interface allowing you to choose which miscellaneous charges you want booked to which categories.
First you must change it from "Unlocked" to either "Custom Default" or "Locked". If it stays in "Unlocked", you cannot edit this page.
Custom Default: This setting allows you to set the default here for all vendors, but it still gives you the option to adjust any settings when editing a specific vendor.
Locked: This setting will apply whatever choices you make here to all vendors and they cannot be adjusted individually within the vendor, only on this page.
Note that in these settings you can also set bulk rules for pulling the information from your accounting system and for handling how handwritten adjustments are used.
And don't forget to click SAVE at the bottom when you are finished!
- If you are wanting to understand more about categories, or restrict the category on a vendor level, please see this article: General Ledger Accounts, Categories, and Category Types
- If you want to learn how to set your products or categories as tax-exempt, please see this article: Make Products or Categories Tax Exempt