Bartercard

How To Check The Bartercard Account Balance Against The Bartercard Balance In Xero

1. Log into Bartercard with the Jo Strictly Savvy login details

2. On the Dashboard under the My Account section check the current Avail. Balance

5. If the Xero Bartercard balance matches the Bartercard balance then that is all you need to do. If it DOESN'T, then you will need to Import a Statement under the Bartercard account in Xero, as per the process below

3. Select the applicable month from the drop-down list under Available statements

4. The statement will be displayed detailing each transaction line, the opening balance, and closing balance

5. In a new window, open SharePoint > Finance > Bartercard Statements

6. Filter the modified column by right-clicking it and selecting Newer to older from the drop-down options

7. Hover over the most recent .csv file and select the three dots to show more options

8. Select Copy to from the options displayed

9. Select Current Library > Bartercard Statements and then click on the Copy here button

10. Hover over the most recent .csv file and select the three dots to show more options

11. Select Rename from the options displayed

1. Rename the file to this month and today's day [Month dd mm yy] e.g. October 24 10 17

2. Select Save

14. Open the .csv file that you just renamed, click on Viewing on the ribbon and select Editing from the drop-down options

15. Clear the contents of any data from row 2 down

16. Referring to the Bartercard statement, input any new statement line detail into the Excel sheet

NOTE: Any deductions MUST have a "-" in front of the amount

17. Save the Excel sheet

18. Log into Xero > Strictly Savvy

19. On the Dashboard page, scroll down to view the Bartercard account and click on the three dots icon at the top right to show more options

20. Select Import a Statement in the Reconcile column

21. Under 3. Upload the bank statement file here... select the Browse button

22. In the new window that opens, locate SharePoint > Finance > Bartercard Statements

23. Select the .csv file that you have just created and select Open

24. You will then return to Xero and select the green Import button

25. Reconcile the Bartercard account in Xero as required