Consolidating Shopify Payments orders
If you're using Shopify Payments to accept payments in your store, you might want to group your payout orders and send them to Xero in a single invoice for quick payout reconciliation. The invoice will take care of working out the total fees, shipping, sales, exchange rates, gift cards, refunds, etc. so it matches the back deposit you receive from Shopify. This is one of the great features that make Reconcile.ly very efPopularConfiguring your Settings
Once connected, we will guide you through two settings screens; the first you can select your account mappings. Then the second will allow you to control how we send orders and what we send. You can change these at any time. Mappings The mappings screen is straightforward, simply select which general ledger account we should map each income or expense type to. We havePopularInventory tracking and COGS reconciliation
COGS aims to fill in the other half of the reconciliation process by sending invoices to Xero to account for the costs you incur when you sell your products. Xero offers different ways to manage SKUs, inventory, and reconciliation and Reconcilely can fit nicely into your workflow based on your use case. HowSome readersCustom mappings
Custom mappings are used to group transactions by product types (from your Shopify store) or even country and map each transaction type to different Xero accounts of your choosing. These will customize the line items in Xero invoices by grouping transactions together, overriding your regular sales mappings. Reconcile.ly offers three Custom Mapping options for you to choose from: (https://storage.crisp.chat/users/helpdesk/webSome readersThe difference between Tracked Inventory and Untracked Inventory in Xero
Xero offers different ways to manage SKUs, inventory and reconciliation and Reconcilely can fit nicely into your workflow based on your use case. How Xero will do its inventory management is first determined by how your item codes are created: Tracked inventory will defer inventory management to Xero. As you record sales against those products, the accounting software will automatically tick inventory up/down for you. While this solution has limitations, it often is good enough for mFew readersExport direct orders to Xero
If you collect your orders' payments with a third-party payment provider or specific gateways (outside Shopify Payments), our Reconcile.ly app will allow you to create a sales invoice for each order made from an external gateway in real-time and export it orders to Xero automatically - unless you set the app to exclude a particular gateway. In your accounting system, these gateways may end up behaving like bank accounts of their own, so it's useful to have invoices on-hand for each order yoFew readersWhen are orders sent to Xero?
Reconcile.ly gives you the option to select at which point we should export the order to Xero. Either when they are Created or when they are Paid. By default, invoices will be created when orders are fully paid. If set to 'Paid', we will send it when the order is fully paid. This is the recommended setup as it will make reconciliation more efficient unless you are expectiFew readersHow can I prevent duplicate contacts on Xero if two customers have the same name?
When an order is created for a new customer, Reconcile.ly can create a new contact in Xero for this customer. By default, we include a unique identifier number to the contact name to reduce the risk of duplicated contacts. That solves this particular problem. This results in contact names including a string of text that looks something like (shopify2845292724335), which is the identifying number of the Shopify customer. (https://storage.crisp.chat/userFew readersInvoice Reference for Direct Orders
Every created invoice in your accounting system can contain a custom string of text as a reference which you can search for when reconciling your accounts. For this, Reconcile.ly offers a variety of dynamic reference options: Authorization Key (Payment) Payment Gateway Order Number Order Number & Payment Gateway Customer names & Payment Gateway Customer names, Address, & Payment Gateway Customer names & Address Customer names &Few readersApply received payments to this bank account
If you're planning to apply partial payment transactions made on Shopify to your bank account connected on Xero, you may set this bank account on the 'Apply received payments to this bank account' option on the app Invoice Preferences section. Once you select a bank account here, then Reconcile.ly will attempt to create a payment within Xero using that bank account against tFew readersExclude orders by Gateway
Some merchants want to ensure that orders from certain gateways won't be sent to Xero. There are different reasons for this, and each merchant might need different exclusions. Fortunately, Reconcile.ly allows setting the app to easily stop some orders from being imported into Xero. To skip over orders made from some gateways, go to the app settings - 'Exclude Orders by Gateway' , and add all the Gateways you do NOT want to be sent to your accounting system. (https://storage.crisp.Few readersHow can I attach invoices for direct orders to an existing contact instead of the default?
When you install Reconcilely for the first time, we create a contact on Xero to assign orders to in case you don't want to create contacts on Xero for each customer. But if you're migrating from another solution, you may already be using a specific Xero contact to assign orders from your store. That's where this new setting comes in. This override will allow you to override the default invoice contact to any contact in your Xero organization. (https://storage.crisp.chat/users/helpdFew readersIs there a way to delay invoices before they are sent to Xero?
If you use an app that edits your orders, you may wish to delay sending orders to Xero to give that app time to do its thing. It's a small but potentially useful workaround in situations where simply waiting solves your use case. You can access this new setting in the Order Settings page.Few readersCreate Xero contacts for Shopify customers
You can set up Reconcile.ly to automatically create, find and assign Xero contacts for each Shopify customer you have. This will attach orders to Xero contacts as they are placed while maintaining synchronized information about the customer. If enabled, the app will create a Xero contact for each Shopify customer you have, and orders made by existing customers will be attachedFew readersHow can I use a Shopify order's due date as the due date for my Xero invoice?
If you're used to sending orders to Xero when they're created, especially in a B2B context, you may find it tedious to manually adjust the due date of these invoices (i.e. to the 21st of the month). There's an option to follow the Shopify order's payment terms and attach the Xero invoice's due date to match that of the order you create or receive on Shopify. You can access thiFew readersInclude orders by tag
Some merchants want to ensure that only certain orders are sent to Xero. Luckily, Reconcile.ly offers an option to apply a filter, and allow just some orders to be exported. For this, you'd need to add these orders a tag or tags. To add tags to your orders, you may do the following: 1- From your Shopify admin, go to Orders 2- Select your order(s) --More actions--Add tags 3- Enter the tag names, and add them. 4- If they aFew readersCustom cash clearing account
If you're planning to apply cash payment recorded on Shopify to a custom cash clearing account connected to your Xero, you may set this bank account on the 'Custom Cash Clearing Account' option available in the app 'Invoice Preferences' section. Once you select the account cash payments should be applied to, then Reconcile.ly will attempt to create a payment within Xero usingFew readersMulti-currency
Multi-currency is one of the things that really depend on your store's configuration and your accounting needs. At the basic configuration, we map the foreign currency to your shop's currency based on the foreign exchange amount that is given by Shopify. However, Reconcile.ly supports the multicurrency feature on higher plans (PRO & Unlimited) so the orders currency is kept when sent to Xero. Nonetheless, your Xero account needsFew readersCompany name for created contacts
If you sell B2B, the odds are that you have orders being made by company accounts and partners. It makes sense to ensure that contacts created for those customers on Xero reflect the company name. Luckily, Reconcile.ly offers the possibility to display the option to use the Billing Company name. This means the app will automatically set the contact name on Xero to the Company name if it is present in the billing details of the order. However, this option will be available only if you set the aFew readersForce created invoices as Paid/Authorized
Direct order invoices in Xero are marked as paid once they have a payment against them; it's not just a status -- it fully depends on a payment existing. When you reconcile an invoice and match it against the actual deposit in the bank feed, that will mark it as paid/authorized. However, if your accountant or bookkeeper needs to have them sent as 'paid' without prior reconciliation with your bank, you may force Reconcile.ly to do so. (https://storage.crisp.chat/users/helpdesk/website/5ac06Few readersSend Order Invoices to Xero as Drafts
You may definitely send order invoices as drafts to your Xero account by following these steps: Go to Reconcile.ly On the left panel, go to 'Rules' Choose the Payment Gateways for which you want the Draft status to apply Then select 'Draft' for sending invoices to Xero Click on 'Active' to activate the rule SaveFew readers