Actuals Errors

This article outlines the steps to take in order to troubleshoot failed Actuals uploads.

Steps

Go to Admin > Actuals.
Scroll to the bottom of the page, and click on the row that says "FAILED".
See if there is an error message at the very bottom of the page that will help you diagnose and resolve the issue.
If not, provide Bullhorn Analytics Support with the Actuals ID that failed, as well as the spreadsheet you tried to upload, via email for us to troubleshoot further on your behalf.

A common reason for files failing to upload is that formula, formatting or rogue symbols (such as ‘%’) are present in the cells. Try removing these before reattempting the upload.
Some of the columns in the CSV template are display only (D - Consultant %, E – Days Worked, and I – Total Margin %) so the entries don’t affect the data displayed in Bullhorn Analytics. Their purpose is to give users a greater understanding of their billing (e.g. my GP is down this month, but I can see that’s because most of my contractors only worked 10 days). If you prefer not to enter data in these cells, just enter ‘0’ (if cells are blank, the upload will fail).
The Exchange Rate needed in column H is sometimes entered the wrong way (e.g. GBP to EUR, rather than EUR to GBP) which gives inflated sales figures at the company level. If this happens, request for the file to be deleted and re-enter.