Integrations
Accountancy

Upload issues

13min

Just set up your integration?

Before following the next steps, we highly recommend ensuring that your accountancy integration is enabled. Not sure how to check if your integration is enabled? Check out our guide: Enabling your integrationο»Ώ.

Check the upload status and "sync messages"

We'd advise taking a look at your accounting configuration settings in Breww (Integrations ->Accountancy->Actions->Configuration). From here, you can check on the upload statuses of your invoices/credit notes/etc (in the All upload statuses tab) and whether any "sync messages" have been generated (in the Sync messagestab) for documents that have failed to upload. These messages can be found in the tab named "Sync messages". These messages should provide the answer as to why specific items haven't been uploaded, which will allow you to resolve the issue either in Breww or your accounting software.

Often these messages come directly from the accounting platform and sometimes can be a little cryptic! If you're unsure how to resolve a specific message, please comment below with the message, and we'll explain what needs to be done.

By default, we also don't sync invoices & other documents up to your accounting provider that were generated before the sync was enabled, but these can be force uploaded from the Upload statuses tab within the configuration menu.

I've fixed the issue in the sync message, but it has still not been uploaded

When you fix an issue described in a sync message, such as adding a missing address on an invoice, this doesn't automatically trigger Breww to re-attempt the upload. To save bombarding the accounting platforms with repeated failures, Breww will re-attempt failed uploads just a couple of times per day and will do them in small batches.

Generally, we'd recommend just waiting for Breww to re-attempt the upload (wait at least 8-10 hours). You can check the "Last seen" column on the sync messages to see if Breww has re-attempted the upload and had the same failure message, or if it's just not yet tried again.

Screenshot 2022-09-08 at 13.53.37|690x176
ο»Ώ

If you need the invoice (or any other document) to be re-uploaded immediately, or you are not sure if your "fix" for the sync message is right, you can force it to re-sync without waiting for Breww to do it automatically. This can be done from the All sync statuses tab and using the force upload button next to the applicable document. You'd need to go through them one-by-one though, so you might find it easier to just wait for Breww to find them. After clicking the upload button, please allow a couple of minutes for them to appear in your accounting software, or for the "Last seen" time to be updated in the "Sync messages" tab.

Screenshot 2022-09-08 at 13.59.57|690x479
ο»Ώ

Understanding specific sync messages

Some common sync messages, that may seem a little cryptic at first, are explained below. Click on a message below to expand its explanation.

There is no account mapped to the external payment gateway "X" and a backup has not been set. Please map the payment gateway to an account or set an account for integration payments.

This means that you have a payment on an order from an integration (such as your web-shop). Breww needs to know which bank account to put the payment against. We'll use "stripe" as the example payment method in this explanation, but this may be different in your case.

Go to the Settings tab in your accountancy integration section in Breww, then scroll down to the section labelled "Integration bank accounts". From here, you can set an account for each payment method ("stripe" in this case), or set a backup to use for all integration payment methods. It looks a bit like this:

Screenshot 2023-02-15 at 09.41.34|690x272
ο»Ώ

If, for example, you accept payments via Stripe or PayPal and want to ensure they always go to a different account, we'd suggest setting an account for both Stripe and PayPal, but leaving the back-up "Integration account" blank. If you had filled the "Integration account" box, this will mean that if you introduce a new payment method in the future (maybe cash on collection), these payments will automatically go to the "Integration account", and you may need to manually reclassify them. If you don't fill the "Integration account" box, then these payments will instead be held up with a sync message and you'll get a chance to set the correct account for these payments before they get uploaded.

If you always want all integration payments, of any method, to go to the same account without being prompted, then fill in the "Integration account" box.

ο»Ώ

"Duplicate invoice number" accountancy integration sync message

On occasions where your invoices are not being uploaded to your accountancy platform, you will usually receive a sync message. Sync messages are returned from your accountancy platform, explaining why it has not been possible to upload your invoice. If the message returned is similar to "This is a duplicate invoice number." it means that Breww has attempted to upload your invoice to your accountancy software, but the invoice number already exists in your accountancy software.

Invoice numbers

If you have just started with Breww but have been trading before joining Breww, you will likely already have created some invoices. When an order is invoiced in Breww, that order number becomes the invoice number. Your first order in Breww will be 1, unless you change this to match the following number in your existing sequence from before joining Breww (you can find out how to do this in our guide: How to change my starting invoice/credit note numberο»Ώ).

If all of your invoices are being created in Breww, then so long as you change your starting invoice number to be greater than your last invoice number in your accountancy software, you shouldn't come across the sync message again, but if you have already raised invoices and had this sync message returned or if there are invoices you are raising in your accountancy platform that you could not for any reason create in Breww (we do highly recommend raising all invoices in Breww to avoid complications) then you will want to use prefixes for invoices that Breww is uploading to your accountancy software.

Using prefixes

To prevent duplicates and ensure your invoices raised from Breww are entirely unique, you can use prefixes like BRW, for example, so that invoice number 1 is uploaded as BRW-1 and is, therefore, not a duplicate of the existing invoice 1 in your accountancy software.

To set up prefixes, navigate to Integrations ->Accountancy and find your accountancy software provider listed, then click Actions ->Configuration and on the settings tab of the configuration under the header "Sync settings" you will see a section for Prefixes where you can enter a unique prefix for your invoices and credit notes.

image|690x333, 75%
ο»Ώ
ο»Ώ

Why are some of my invoices appearing as "Don't upload"?

An invoice can be marked as "Don't upload" for a few reasons.

The first reason is that when you first enable your accountancy integration, all previously "Invoiced" orders are set as "Don't upload". Breww assumes that the invoices have been dealt with manually in your accounting software before this. So to prevent duplicates from being accidentally uploaded, they are marked as "Don't upload" as a precaution. Although you can then still manually override this on a per-invoice basis.

Ecommerce & POS integrations can also mark invoices as "Don't upload". The majority of these allow you to specify whether you'd like orders downloaded from the ecommerce platform to be uploaded or not to your accountancy software. If you select that you don't, Breww will mark them as "Don't upload" when they are imported.

The only platform-specific reason is Sage 50, which doesn't allow zero-value invoices. So if you're using Sage 50, Breww marks these invoices as "Don't upload".

ο»Ώ

Why are some of my invoices appearing as "Pending"?

As a general rule, invoices should not sit as pending for a prolonged amount of time. When an invoice is triggered to upload to your accountancy platform, it is usually uploaded within a minute or two but may take up to 15 minutes; however, on occasions where it has not been possible to sync data on this first attempt, then Breww will re-attempt every 8 hours, and the invoice will remain as pending.

For any invoices that are pending, you do have the option to force upload them through the Upload statuses tab, which will initiate another attempt to upload your invoice; this should again usually be completed within 15 minutes.

If you have any invoices sitting as pending after an attempted force upload or after 8 hours, please get in touch with one of our team, and we can look into this for you.

ο»Ώ

This article applies to all items that Breww will upload to your accounting software, including:

  • Invoices
  • Credit notes
  • Customers
  • Inventory receipts (bills)
  • Payments received against invoices

This also applies to all of our automated accounting integrations, including:

  • Xero
  • QuickBooks
  • Sage Accounting
  • Clear Books
  • KashFlow
  • Visma eAccounting
  • Exact Online
  • Twinfield
  • Sage 200

ο»Ώ