Skip to main content

MarginEdge & QuickBooks Online | Integration FAQs

Jenny Vaughn
Updated

How does this work?

  1. What does MarginEdge send to QuickBooks?  

MarginEdge sends invoices and journal entries (sales  data, inventory adjustments and non-AP expenses). Invoices, sent as bills, show up in Accounts Payable (AP). These bills can be paid in QuickBooks.  

*Please note that QuickBooks Simple Start DOES NOT support importing Bills (vendor invoices). You will need to upgrade your QuickBooks subscription to Essentials, Plus, or Advanced in order to export from MarginEdge.

*Also note that QuickBooks Essentials does not support the Classes or Locations features. If you plan on using those features you will need to upgrade your QuickBooks subscription to Plus or Advanced.

  1. How does data flow from MarginEdge to QuickBooks? 

Data flows easily between the two cloud-based systems. You can choose to be the gate-keeper on what sends from MarginEdge into QuickBooks (“manual mode”) or you can choose to let the data send automatically  (“auto-mode”). See question 8 and 9 for more details on these options.  

  1. Can I have multiple [me] units flow into the same Quickbooks account?

Yes! If you want to keep your units separated in [me] for clean record keeping but want them to all flow into the same Quickbooks account, that can work. Some people use "classes" to keep the data separated, but it is not required. 

 

Wait, you’re not going to mess with my QuickBooks, are you?

  1. Will I have control over the content and the timing of what comes into QuickBooks? 

Yes, you’ll have several different ways to modify and control how MarginEdge sends your data.  

CONTENT: 

  • Invoices – at onboarding, you can determine how invoices are coded; from then on, you can control:  
    • category totals (MarginEdge and accounting categories) 
    • dates (payment dates, due dates, etc.) 
    • vendors (with a suite of options for how each vendor is processed)  
  • Sales entries – you can control:  
    • what categories they are associated with 
    • what lines are included 
    • how they look (sales entries are identical to before) 
  • Inventory adjustments – nothing will be posted into QuickBooks until you close the adjustment. 

TIMING: 

  • By default, nothing is sent to your accounting system without your authorization (manual mode) 
  • Invoices are processed 24-48 hours after MarginEdge  receives them; they are then available for approval to  flow into your accounting system.  
  • For your convenience, invoices can flow automatically into QuickBooks without any layers of approval (auto mode).  
  1. Does MarginEdge edit/update/manipulate my vendors or chart of accounts? 

No! We never edit or update your chart of accounts in QuickBooks in any way.  

  1. Can you split a product into different accounting categories? 

Yes. You can split products into accounting categories by percentage (e.g. 30% of lemons go to the bar and 70%  go to the kitchen).  [Learn more in this article on Product Categories] 

  1. Does MarginEdge change transactions after posting in QuickBooks? 

No! Once we send an invoice, payment, or sales entry to QuickBooks, we never adjust it. If you need to make  a change, you can delete it in QuickBooks, and then resend the data from MarginEdge; but we never alter data in your accounting system.  

If you use Bill Pay, when a bill is paid we will mark it as paid in accounting (but the bill data will not change in any way). See question 15 and 16 for more information  on Bill Pay.  

  1. Does MarginEdge control payment terms for my  vendors? 

No. The source of payment terms is the accounting system. When MarginEdge sends bills to QuickBooks, the due dates are based on the vendor terms you set up in QuickBooks. 

  1. Can I have complete control over what gets sent to my accounting system? 

Yes. For invoices, inventories and sales, there are options to be in “manual mode.” This means that you  must manually select every invoice, sales entry and  inventory count to be sent to accounting. The alternative  is to be in “auto-mode.” We find most clients who start in  manual mode quickly switch to auto-mode once they are comfortable with the platform.  [Learn more in this article on export settings] 

  1. What gets sent to accounting automatically in  auto-mode? 

In auto-mode (used by 90%+ of our clients), every invoice that is closed is immediately sent to accounting. Similarly, each day’s sales entries flow into accounting early the next morning. The accountant does not have to select individual invoices or sales entries to be sent to accounting.  

  1. If I’m in auto-mode, how will I use MarginEdge? 

In general, for invoice and sales data, you won’t need to go into MarginEdge. However, for some tasks, you’ll need to use MarginEdge to: 

  • research invoices, quickly get invoice info by vendor or by period for easy vendor statement reconciliation 
  • investigate an invoice missing from the  accounting system 
  • change the category for a product 
  • change a setting for a vendor  

Invoice Processing  

  1. Can I flag invoices for review? 

Absolutely. We have settings for requiring a second layer of review. You can choose this option for all invoices, invoices above a certain dollar amount or for any accounting category.  [Learn more in this article on Setting up Invoice Approval] 

  1. What if a really old invoice comes in? Will I know if that happens? 

If you’ve closed the books for the period that the invoice is dated in, we will code the invoice to the current period. If you have not closed the books for the period, the invoice will be coded in that period. 

We have a Close Book feature that lets you lock the  books a set number of hours after the period ends. This  ensures MarginEdge stays in sync with QuickBooks and  past financial reports.  

  1. What happens if I’ve already paid an invoice by check or ACH? 

If an invoice is uploaded that has a payment indicated (e.g., a handwritten check number or ACH debit is noted), we will send both the invoice AND the payment info over to accounting. 

  1. What happens if I’ve already paid an invoice by  credit card? 

For invoices paid by credit card, MarginEdge sends these expenses not as a bill and as AP, but as a journal entry, booking the amount to an expense (e.g., $100 to Food), and booking the amount also to the credit card account you specified.  

Paying Bills 

  1. Could I pay bills right from the MarginEdge platform? 

Yes! With our Bill Pay feature, you can select invoices and schedule them to be paid.  

  1. How will QuickBooks know I’ve paid these invoices? 

Payments are synced to QuickBooks as checks marking the invoices as paid, making bank reconciliation easy. 

Sales data 

  1. Can MarginEdge use classes for sales and invoice data?  

Yes and yes.  

  1. What do sales from MarginEdge look like in QuickBooks? 

Journal entries. MarginEdge exports sales information  (including payment methods, comps, discounts, etc.) from the client’s POS system early each morning  following the close of business. Sales can be customized  to fit your needs and appear how you’ve always formatted the data.  

  1. Can MarginEdge send sales entries as sales receipts rather than as journal entries? 

No, we only support journal entries.  

Support

  1. Are there charges / limits to support?

No, support is no charge and unlimited

Further Reading