How to Export to Accounting with QuickBooks Online, Intacct or Xero

The first thing to consider when exporting invoices, sales entries or an inventory adjustment from MarginEdge is how your accounting system integration is configured. To find these settings, go to Setup > Integrations and select your accounting system.

 Screen_Shot_2019-10-07_at_1.22.43_PM.png

Here you will see drop-downs that specify how MarginEdge syncs with your accounting system. These settings can be set individually for orders (invoices), sales entries (daily sales journals) and inventory entries (inventory adjustments).

 Screen_Shot_2019-10-07_at_1.22.49_PM.png

To adjust your settings, click on the dropdown menu and select your preferred sync option. The options are: 

  • Automatically – As soon as we finish processing an invoice, have received a balanced sales entry or you have posted an inventory adjustment to accounting, we will automatically sync with your accounting system and export the data. 
  • Only Manually Selected – When we finish processing invoices, have received a balanced sales entry or you have an inventory adjustment to post, these transactions will appear in your export page where you can manually select and export them to your accounting system. All data will immediately populate in your MarginEdge reports, and invoices can be paid with Bill Pay; however, nothing will flow into your accounting system until you manually send the data.
  • Pause Temporarily – This option will prevent any data from exporting to your accounting system until you select a different option.

 

Exporting in Manual Mode

By default, all restaurant units in MarginEdge are set to manual. To export to your accounting system, go to Accounting > Export. Here you will see everything that is ready to export.

Screen_Shot_2019-10-07_at_1.22.59_PM.png

 By default, this list will display only items dated within your current accounting period. However, by changing the date range selector you can choose any date range you desire.

 Screen_Shot_2019-10-07_at_1.23.06_PM.png

If there are invoices that have not finished reconciling (because MarginEdge is still processing them) or they are in error status outside your selected date range, you will see a notification on the top of the page (see example below).

 Screen_Shot_2019-10-07_at_1.23.13_PM.png

 

Export Screen statuses and what they mean:

Ready                       

Ready to export to your accounting system 

Pending                   

Anything in pending status has been sent to your accounting system but may not have been received yet. Usually, refreshing your browser window will change this status to Sent. 

Sent                          

Successfully exported to your accounting system

Needs Attention   

The vendor needs to be mapped or adjusted before this invoice can be exported to your accounting system. Click here for instructions on how to map your vendors.

Error                         

Export to your accounting system has failed. Click the Error text in red and a pop-up will appear that shows the error message. If you are unsure how to resolve the error, email help@marginedge.com and we will help you fix it. Daily sales journals that are not balanced will automatically be in error status. If you click the error status, you will see the message, “total debits do not equal total credits.”

Skipped ­                  

Transactions will not be exported to your accounting system. By default, anything in skipped status will not appear on your export screen; however, you can view skipped invoices by changing your filter settings.

-------------------------------

By default, your export screen will show all invoices, sales entries or inventory adjustments in in Ready, Pending, Needs Attention or Error status. To adjust what is included or excluded click the filter button.

 Screen_Shot_2019-10-04_at_11.28.15_AM.png

How to Manually Export to Accounting

To export to your accounting system, click the checkbox on the left side of the screen (this can be done one line at a time, or you can select everything you want to export at once) and press the green Send button. This data will then flow over to your accounting system.

 

Example:

To export to your accounting system, select any invoices or journal entries you would like to export:

 Screen_Shot_2019-10-07_at_1.23.33_PM.png 

Click the green Send button.

Screen_Shot_2019-10-07_at_1.23.37_PM.png

The status will change to Sent in MarginEdge.

 Screen_Shot_2019-10-07_at_1.23.46_PM.png

Your data will appear in your accounting system (example below from QuickBooks Online):


Screen_Shot_2019-10-07_at_1.23.50_PM.png

Skip Sending to Accounting

To skip sending data to your accounting system, repeat the same process, but click Skip instead of Send. This will keep the information in MarginEdge but clear the selected item(s) from your export screen.

Screen_Shot_2019-10-07_at_1.23.56_PM.png

Exporting in Automatic Mode

In automatic mode, invoices, payments, sales entries, and inventory adjustment will export to your accounting system without any manual import selection. The accounting export screen will still store all the invoices and journal entries exported to your accounting system and show any invoices that have failed to import because they need mapping or are in error status.

 

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.