- \n\t
Smart Rules for advanced data entry customization in QuickBooks Online\/Desktop<\/a><\/p><\/li>\n\t
Undo feature to fix any mess-up in your books<\/a><\/p><\/li>\n\t
Product mapping for correct Income categorization and detailed Profit and Loss<\/a><\/p><\/li>\n
Reconciliation troubleshooting features<\/a><\/p><\/li>\n<\/ol>\n\n\n\n
Smart rules<\/strong><\/h2>\n\n\n\n
Designed for<\/strong>: accountants and business owners for advanced data entry customization and filling in gaps with missing data in QuickBooks Online\/Desktop.
Use cases it covers<\/strong>: classes and locations assignment, inventory tracking, income, expense and fee categorization, tax filing, linked items\/customers\/payment method updating, reminders, thank you and marketing emails to your customers during the sync of the payment.
How to use it<\/strong>: Smart rules functionality is a kind of advanced setting adjustment that provides multiple options to add missing info to synced transactions in QuickBooks Online\/Desktop or send your clients reminders and notifications. These smart configs provide you with detailed info and reports in QuickBooks that allow you to gather some insights for efficient analytics of your business.<\/p>\n\n\n\nRules work on the basis of if-then conditions so you can create flows and make the system adapt to your needs. The process contains 2 phases<\/strong>: <\/p>\n\n\n\n
- Synchronization of a transaction from the payment processor\/e-commerce to your accounting system. <\/li>
- Update of the created QuickBooks transaction based on the information inside of it, which happens almost instantly based on the conditions of the flow.<\/li><\/ol>\n\n\n\n
![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Update-line-1-3.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Update-line-2-3.png\")
<\/div><\/div><\/div><\/div>\n\n\n\nLearn more How Smart Rules work in Synder<\/a> and what problems can they solve for you (check out the Templates <\/em>tab in Synder Smart Rules<\/strong> to test it): <\/p>\n\n\n\n
- Classes assignment<\/strong>. If an item in QuickBooks Online\/Desktop already has a class associated, Synder will automatically apply the corresponding class (if the product in the transaction and in QuickBooks match), however, you might need to apply classes based on different conditions. With Synder you can Apply classes to transactions<\/a> and product <\/a>lines<\/a>, and Apply classes to Expenses<\/a> (your business Expenses and Fees) automatically. <\/li>
- Locations tracking<\/strong>. You can assign a default location for each platform in Synder settings or use the Smart Rules feature to Apply locations to synced transactions<\/a> based on other conditions. Check out both options described in the help guide and choose which one suits you best. <\/li><\/ul>\n\n\n\n
Tip<\/strong>: You can use location tracking to separate transactions coming from different sales channels in your P&L, thus you can check how a particular product is being sold on different platforms (eBay, Amazon, Stripe, PayPal etc.) and determine what is more profitable for you. <\/p>\n\n\n\n
- Income categorization and Inventory tracking<\/strong>. Income categorization happens depending on the item linked. However, if general Product\/Service settings<\/a> do not cover your needs completely, Smart Rules can be of use to edit items and income categories and assign the correct item to transactions so that your inventory in QuickBooks is up to date. You can edit products linked to QuickBooks Invoices or Sales Receipts synced by Synder based on various conditions like shipping address, description, amount, etc.<\/li>
- Expense and fee categorization<\/strong>. There is no need to categorize expenses manually in QuickBooks as with Smart Rules you can let Synder Apply categories to expenses automatically<\/a> depending on the description<\/a>, vendor,<\/a> or other conditions, and categorize processing and application fees<\/a>.<\/li>
- Tax filing<\/strong>. If you feel like general tax configs<\/a> are not enough and you need some adjustments according to your flow (e.g. all sales are tax inclusive, but gift cards should be tax-exempt or you would like to assign taxes depending on the shipping address of your clients), use Smart Rules to apply the tax rate needed based on the Product name, Shipping address or other conditions of your choice.<\/li>
- Send reminders and notifications to your customers<\/strong>. Build up a rule to send Invoice payment reminders<\/strong> before<\/a> and after<\/a> the due date, and automate your marketing campaigns<\/a>.<\/li><\/ul>\n\n\n\n
Undo (Rollback) feature<\/strong><\/h2>\n\n\n\n
Designed for<\/strong>: accountants and business owners to remove incorrect data from your books in several clicks.
Use cases it covers<\/strong>: clear books from the wrong data, remove duplicate entries (due to manual input or other applications).
How to use it<\/strong>: If you are not satisfied with the synchronized data for some reason, roll it back<\/a> from the Synder side in bulk to clear your books. Just a couple of clicks and all synced data is deleted so that you can adjust the configs and resync the correct info to your books.
Please note:<\/strong> rollback does not reinstate the number of syncs available.<\/em><\/p>\n\n\n\n![\"\"](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2024\/06\/Features-of-Synder-Taking-Your-Experience-to-the-Next-Level-3-1024x417.png\")
<\/figure>\n\n\n\nProduct mapping for income categorization<\/strong><\/h2>\n\n\n\n
Designed for<\/strong>: accountants and eCommerce business owners for accurate auto-categorization of synced income and detailed P&L report.
Use cases it covers<\/strong>: item names in the accounting platform and the sales channel do not match exactly, item names differ in each sales channel, match product names with SKUs automatically.
How to use it<\/strong>: Synder categorizes transactions automatically based on the linked item details, if product names in your accounting system and payment\/e-Commerce provider match exactly, the transaction will go to the correct Revenue account by default. If there is no match found, Synder creates a new item in your books or you can set it up to apply default or generic item. Check out this guide to learn more about Synder Product\/Service settings<\/a>.
If Synder does not recognize and match the item automatically<\/strong>, the Product mapping feature<\/a> can be a life-saver. You can specify the item names or SKUs in the Product mapping section of the Product\/Service settings and Synder will match the mapped products automatically in all further synchronizations with these items. <\/p>\n\n\n\nTips and tricks<\/strong>: Items can be matched either by Product names or SKUs. Let\u2019s compare three use cases with their solutions:<\/p>\n\n\n\n
- Case<\/strong>: Product names in QuickBooks\/Xero and Square do not match exactly (e.g. \u201cApples\u201d in QuickBooks and \u201cGreen apples\u201d in Square). Solution<\/strong>: Product mapping by product names on both sides (select QB\/Xero item name in the left QB\/Xero column and paste Square item name in the right Square column in Synder Product mapping).<\/li>
- Case<\/strong>: Item names differ in Etsy, eBay and Shopify, but correspond to a single product in QuickBooks\/Xero. Solution<\/strong>: Product mapping by product names on both sides for each sales channel (set up product mapping by name in Synder settings for Etsy, eBay and Shopify correspondingly). <\/li>
- Case<\/strong>: You track items by SKUs in Amazon, but by Product names in QuickBooks (QuickBooks items do not have any SKUs or they differ from Amazon ones). Solution<\/strong>: Map QuickBooks Products with Amazon SKUs (select QuickBooks\/Xero item names in the left QB column and paste Amazon SKU in the right Amazon column in Synder Product mapping).<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2024\/07\/Product-mapping-for-qbo-1024x518.png\")
<\/figure>\n\n\n\nReconciliation troubleshooting features<\/strong><\/h2>\n\n\n\n
Designed for<\/strong>: accountants and business owners for seamless reconciliation of synced data in one click.
Use cases it covers<\/strong>: Failed and Not parsed transactions recording, missing integrations, reconciliation of multicurrency transactions, 0-duplicate data entry, missing transactions.
How to use it<\/strong>: Synder simplifies the accounting by automating the data entry flow allowing for smooth reconciliation of synced data in your books. All it takes to prepare your books for reconciliation is one click to confirm the match with your bank statement.<\/p>\n\n\n\nLearn more about one-click reconciliation with Synder in our help guides on the matter:<\/p>\n\n\n\n
- Reconcile synced transactions in QuickBooks Online with Synder<\/a><\/li>
- Reconcile your checking bank account in Xero<\/a><\/li>
- Automatic Xero Bank Reconciliation feature<\/a><\/li><\/ul>\n\n\n\n
Syncing sales, expenses and payouts Synder mirrors the real money flow in your accounting so that your Clearing account<\/a> balance is equal to the Sales platform\u2019s balance (e.g. your Stripe (required for Synder)<\/em> account balance in your accounting company equals your current Stripe balance) and the net sales amounts are deposited into your Checking account that represents your Bank account in your accounting. However, if you noticed that balances do not match and you\u2019ve faced challenges reconciling your accounts, check out possible reasons and Synder solutions<\/strong> below:<\/p>\n\n\n\n
- Problem<\/strong>: Balances do not match due to \u201cNot Parsed\u201d transactions<\/strong> that are not supported yet or \u201cFailed\u201d transactions<\/strong> that cannot be synchronized at the moment. There might be some platform specific transaction types that Synder do not support yet or transactions that Failed to sync for some reason (and you cannot resync them), however, they show up in Synder as \u201cNot Parsed\u201d or \u201cFailed\u201d so that you could track them and either record manually or import in bulk till they are supported for the auto-sync in Synder.
Solution<\/strong>: Filter and select the transactions needed (e.g. filter them by the \u201cNot Parsed\u201d or \u201cFailed\u201d status) and Export them to an Excel spreadsheet using the Action<\/strong> button for bulk actions \u2192 Export to excel. Once you have all missing transactions in a separate spreadsheet you can enter them manually or pull in your accounting system using the Excel import<\/strong><\/a> <\/strong>feature of Synder.<\/li><\/ol>\n\n\n\n![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Export-failed-1.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Export-failed-2.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Export-failed-3.png\")
<\/div><\/div><\/div><\/div>\n\n\n\n- Problem<\/strong>: Discrepancy due to not supported integrations<\/strong>. If you use some sales platforms that cannot be connected to Synder as a direct integration<\/a> and struggle recording and reconciling these data in your books, take advantage of the Excel import functionality to pull all transactions into your accounting system. Solution<\/strong>: Export transactions needed from your payment or e-Commerce platform into an Excel spreadsheet and import the data to your books using Synder Excel import feature<\/a>.<\/li><\/ol>\n\n\n\n
![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Import-excel-1.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Import-excel-2.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Import-excel-3.png\")
<\/div><\/div>![\"Slider](\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2021\/06\/Import-excel-4.png\")
- Problem<\/strong>: Discrepancy due to not supported integrations<\/strong>. If you use some sales platforms that cannot be connected to Synder as a direct integration<\/a> and struggle recording and reconciling these data in your books, take advantage of the Excel import functionality to pull all transactions into your accounting system. Solution<\/strong>: Export transactions needed from your payment or e-Commerce platform into an Excel spreadsheet and import the data to your books using Synder Excel import feature<\/a>.<\/li><\/ol>\n\n\n\n
- Reconcile your checking bank account in Xero<\/a><\/li>
- Case<\/strong>: Item names differ in Etsy, eBay and Shopify, but correspond to a single product in QuickBooks\/Xero. Solution<\/strong>: Product mapping by product names on both sides for each sales channel (set up product mapping by name in Synder settings for Etsy, eBay and Shopify correspondingly). <\/li>
- Expense and fee categorization<\/strong>. There is no need to categorize expenses manually in QuickBooks as with Smart Rules you can let Synder Apply categories to expenses automatically<\/a> depending on the description<\/a>, vendor,<\/a> or other conditions, and categorize processing and application fees<\/a>.<\/li>
- Locations tracking<\/strong>. You can assign a default location for each platform in Synder settings or use the Smart Rules feature to Apply locations to synced transactions<\/a> based on other conditions. Check out both options described in the help guide and choose which one suits you best. <\/li><\/ul>\n\n\n\n
- Classes assignment<\/strong>. If an item in QuickBooks Online\/Desktop already has a class associated, Synder will automatically apply the corresponding class (if the product in the transaction and in QuickBooks match), however, you might need to apply classes based on different conditions. With Synder you can Apply classes to transactions<\/a> and product <\/a>lines<\/a>, and Apply classes to Expenses<\/a> (your business Expenses and Fees) automatically. <\/li>