Accountancy

initial integration set up breww is integrated with a number of accountancy platforms this guide covers breww's automated accountancy integrations, which all work in roughly the same way, and the information on this page applies to them all unless otherwise stated xero quickbooks online sage accounting (sometimes known as sage one or sage business cloud) clear books kashflow visma eaccounting exact online twinfield sage 200 if you are using one of breww's manual accountancy integrations, please see manual accountancy integrations docid\ frzyuh8qw0womab0enqcc sage 50 connecting breww to your provider the first step is to grant breww access to your account with your provider when this is first done, nothing will sync initially and you'll get a chance to configure how you'd like the integration to work before enabling syncing to connect, navigate to our integrations > accountancy page and then click the set up \[software] integration button next, you'll be able to configure a few basic settings, such as which types of data should be synced, optional prefixes for invoice and credit note numbers, etc the next steps vary slightly between the platforms (typically, we redirect you to your provider for you to authorise our access), but please just follow the steps shown on screen this should guide you through the applicable authorisation process, and you'll be back in breww in just a moment mapping & downloading customers & suppliers when you raise an invoice in breww, we will push this to your accountancy provider at this point, breww will create a customer in your accountancy provider to attach the invoice to when this customer has subsequent invoices, breww will add these to the same accountancy provider customer that it created the first time this is all well and good if this is a brand new customer that doesn't already exist in your accounting software, prior to you joining breww, however, if any of your customers already exist in your accountancy software and breww, you'll want to "map" them together so that breww knows this customer already exists in your accountancy provider and puts the orders against the right customer in your accountancy provider if you have any customers in your accountancy provider already that are the same as existing customers in breww (or you'd like them in breww, and they're only in your provider), you can head to the customer mapping tool by going integrations > accountancy and next to your accountant provider select actions > configuration , then click the map and download customers button on the right you'll be presented with a list of your customers in the accountancy software on the left, and on the right, you can choose the corresponding customer in breww you can also choose "create as new customer in breww" which will cause the customer to be downloaded from the accountancy provider to breww and mapped make sure you click the sync customers button after each page of changes and before navigating to a different page, or the customers on the previous page will not be saved there is also a helpful auto allocation button to get breww to automatically attempt to map your breww customers to those in your accountancy provider we do this with an exact match on the name of the customer mapping suppliers is almost an identical process, except you will use the map and download suppliers button instead chart of accounts (nominal codes) you will be able to choose the accounts you would like to use by selecting the accounts & tracking categories button you will then be able to select the actions button, followed by import accounts from here, you can choose the accounts that you'd like breww to be able to use once the accounts have been downloaded, you can map your default sales and default bank accounts if you wish for payments of different methods to go into different accounts in your accountancy provider, you can set these in the settings here too if you don't, just leave them blank for even more fine grain control, you can also set an account on any customers, customer type, and parent companies in breww for their sales to go into (rather than the default) likewise, you can do the same for any product within breww if you prefer to split sales in this way finally, there is a config option to configure which account should take precedence in a conflict (this is discussed further here chart of accounts docid\ lhkdr7krywczmkfumx9rr ) if you're not sure what this all means, don't worry about these options sync settings sync setting are found in the settings tab of your integration configuration found by heading to integrations → accountancy and next to your accountant provider select actions → configuration you can configure options surrounding your sync from here, including which types of data should be synced (customers, invoices & payments) we will never download an invoice from your accountancy provider, we'll only ever upload invoices from breww to the accountancy provider for any of "our" invoices, we will sync payments relating to them both ways so if you add a payment in breww, we'll upload it for you and if you add a payment in your accountancy provider we'll download this back to breww enable syncing this is the main toggle to set if you'd like breww to sync with your accountancy provider this will be disabled by default so you have a chance to map your customers, chart of accounts and configure the service to how you'd like it to work when you're ready, simply enable the sync once enabled, data will be synced to your accountancy provider in the background we don't upload orders to your accountancy provider until they have been invoiced in breww what data flows between breww and my accountancy software? although we aim to ensure that all accountancy integrations work in the same way, some differences in what is supported by the other platform determine what breww can and cannot sync xero uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ✅ ✅ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ✅ ✅ inventory receipts ✅ ❌ quickbooks online uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ✅ ✅ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ✅ ✅ inventory receipts ✅ ❌ sage accounting uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ✅ ✅ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ✅ ✅ inventory receipts ✅ ❌ exact online uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ❌ ❌ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ❌ ❌ inventory receipts ✅ ❌ kashflow uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ❌ ❌ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ✅ ❌ inventory receipts ✅ ❌ sage 50 (uk) uploaded downloaded invoices ✅ manual ❌ voiding invoices ❌ ❌ customers & contacts ❌ ✅ manual invoice payments ❌ ❌ payments on accounts ❌ ❌ credit notes ✅ manual ❌ voiding credit notes ❌ ❌ credit note allocations ❌ ❌ inventory receipts ❌ ❌ clearbooks uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ❌ ❌ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ❌ ❌ inventory receipts ✅ ❌ visma eaccounting uploaded downloaded invoices ✅ ❌ voiding invoices ❌ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ❌ ❌ credit notes ✅ ❌ voiding credit notes ❌ ❌ credit note allocations ❌ ❌ inventory receipts ✅ ❌ twinfield uploaded downloaded invoices ✅ ❌ voiding invoices ✅ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ❌ ❌ credit notes ✅ ❌ voiding credit notes ✅ ❌ credit note allocations ✅ ❌ inventory receipts ✅ ❌ sage 200 uploaded downloaded invoices ✅ ❌ voiding invoices ❌ ❌ customers & contacts ✅ ✅ invoice payments ✅ ✅ payments on accounts ✅ ✅ credit notes ✅ ❌ voiding credit notes ❌ ❌ credit note allocations ✅ ✅ inventory receipts ✅ ❌ how does data flow between breww and my accountancy software order flow graph td a\[draft order] > b\[confirmed order] b > c\[invoiced order] c > u(uploaded to accountancy software) c > p\[payments & refunds] p > u u > p p > c style u fill #15c377,color #fff bill (purchase) flow graph td a\["purchase order (optional)"] > b\[inventory receipt 'draft'] b > c\[inventory receipt 'added to stock'] c > d\[inventory receipt 'invoiced by supplier'] d > u(uploaded to accountancy software) style u fill #15c377,color #fff sync messages if breww is unable to upload something (e g an invoice, credit note, payment, etc) to your accounting platform, it will raise a "sync message" for you and show you a warning number in the "integrations" main menu these messages should explain why the item couldn't be uploaded, so that you can resolve the issue for more information on resolving sync messages, please see upload issues docid\ b2ihvbjf7x7zz7ydq1kdd once an issue has been resolved, you can either manually force the item to re try uploading (from the "all sync statuses" tab) or wait for breww to try it again automatically breww will try all stuck items again every 8 10 hours just getting started with breww? the next guide is importing packaged stock docid\ wjfx0nheufxuambnbokze , or you can return to the getting started guide docid\ mdxf f trhvx1layeovsa