If you choose to complete your report by uploading a prepared file with all your data, the system will then prompt you to match your inputs to the values our system expects.
First, the system will ask you to confirm where the data is coming from and where it will be uploaded to.
- In the “Select a sheet to load data from” section, select “Transactions” which is the sheet where the transactions are included on your report
- In the “Select a sheet to import this data to” section, select the “Add transactions” option
Next, the system will confirm that the data you’ve entered matches what is expected. It does this in two ways:
Column header matching
The system will match each column header in your file to the column header our system expects. If your columns have different titles (as in the screenshot below—“DATE“ vs “Invoice Date*“) the system will try to find the best match. You can change this column mapping by clicking the dropdown menu next to the column name.
Data matching
Some fields (like the ones asking about suppliers or products) check to make sure that the values you’ve entered match the values we expect. This step allows you to correct all these values at once.
For these fields, all unique values from your uploaded sheet will be shown, and you’ll have the ability to map each of these to expected values. The system will do its best to guess what you meant with each value, but it may not be able to properly identify each one. To map these correctly, select the dropdown in the ”Destination Values” column and pick the appropriate value.
Sometimes the system might incorrectly guess what you meant with a given value, so it’s important to review all of these items before moving onto the next step.
Once you've finished matching all your data, you can click ”Continue” at the top of the screen to view your updated report and make additional in-line edits, if you’d like.