How do I connect MRPeasy and QuickBooks Online?
Read more here: Integration between MRPeasy and QuickBooks.
Can I assign different income accounts to different items in QuickBooks Online?
Do items need to exist in QuickBooks Online before invoices are sent there?
If a customer doesn’t exist in QuickBooks Online, and you send an invoice from MRPeasy, will it create the new customer in QuickBooks Online?
When I send an invoice from MRPeasy, does it overwrite customer and item details in QuickBooks Online?
I use QuickBooks Online in the US. When I send a purchase order with tax from MRPeasy to QuickBooks Online, I get the message “Please create a tax for QuickBooks.” What should I do?
Create your POs in MRPeasy the same way you would create invoices in QuickBooks Online.
If you don’t enter tax separately in QuickBooks Online, don’t enter it separately in MRPeasy either.
QuickBooks Online works differently in each country. For example, the Australian version has a separate tax field on bills, and you can set up tax options such as “Collected on purchases” and “Purchase tax is reclaimable.” The US version doesn’t have these features.
Which MRPeasy reports can I compare with my QuickBooks Online balances?
If your integration is set up well and QuickBooks Online is used in a consistent way, the MRPeasy reports below should match your QuickBooks Online accounts exactly. With other setups, the figures may be harder to compare.
1. The Stock → Stock movements report shows all movements of goods and your inventory balance. Note that WIP in this report means something different from WIP in the QuickBooks Online integration. Here, WIP only includes the value of materials used in unfinished production.
Read more about this report: /resources/user-manual/stock/movement/
2. In the QuickBooks Online integration, WIP means the total cost of unfinished manufacturing orders, including direct labor and applied manufacturing overhead. You can find this total in the Production planning → Statistics reports by looking at current unfinished manufacturing orders.
3. If the Standard Accounting module is enabled, the "Work In Progress" account will reflect WIP the same way as the QuickBooks Online integration. Inventory accounts can also be configured to reflect those in QuickBooks Online.
4. When comparing balances, keep these limitations of the integration in mind:
Transactions in MRPeasy and QuickBooks Online may have different dates.
- In MRPeasy, a transaction can sometimes be backdated, meaning it’s created later but takes effect from an earlier date.
- Transactions are never backdated in QuickBooks Online. They’re posted with the date of the sync.
Automatic synchronization happens once a day, in the evening. To sync immediately, click Synchronize now in Settings → System settings → Integrations → QuickBooks Online.
Sometimes the figures may differ
The integration doesn’t sync balances by comparing accounts in MRPeasy and QuickBooks Online. Instead, it posts complete transactions to the matching accounts. Your QuickBooks Online balances may also be affected by:
- Different starting balances
- Transactions entered directly in QuickBooks Online
- Non-standard account mappings, for example, a product’s inventory account mapped to the WIP account
What always matches exactly
- The manual journals that MRPeasy creates in QuickBooks Online always match the detailed reports in MRPeasy.
- You can find these reports in Settings → System settings → Integrations → QuickBooks → Synchronization logs.