Quick Reference Guide - Monthly Process

In the following article you can locate an Export guide for the Accounting Software you use.

Then you can visit the article Monthly Process Pt.2 to see how to import your data.

 

BankLink

Create Profit and Loss

- Open BankLink.

- In BankLink go to reports and choose Profit & Loss Report.

- Export data in CSV Format for chosen month required and include chart codes.

- Save BankLink CSV file with Store, Month, and Year, then move to a destination folder e.g. Demo Store October 2015 Sales.

 

eAccounts

1. Uploading Data

- Profit & Loss and Balance Sheet data is automatically uploaded to the portal by eAccounts. Data will be automatically mapped to the correct category each night.

 

2. Mapping Data

- Your eAccounts Chart of Accounts will already be mapped to the corresponding account names in the portal and will map the new month's Upload data automatically.

- You can go to Monthly Process Pt.2 to view a guide on map checking and re-mapping accounts.

 

Maxim

1. Create Trial Balance 

- Open Maxim.

- Export Trial Balance data in CSV Format for the month required.

- Save Maxim CSV file with Store, Month, and Year, then move to a destination folder e.g. Demo Store October 2015 Sales.

 

MYOB Accountants Office

1. Create Trial Balance

- Open MYOB AO and select 'TB Print'.

- Select 'Start Month' and 'End Month' for required monthly period, e.g. April 2015 & April 2015 to show April results only. Ensure only box ticked is 'Selected Period'.

- Save MYOB AO file with Store, Month, and Year, then move to a destination folder e.g. Demo Store October 2015.

 

MYOB

1. Create General Ledger Summary

- Open MYOB. 

- Export General Ledger Summary in CSV Format for chose month required.

- Save MYOB CSV file with Store, Month, and Year, then move to a destination folder e.g. Demo Store October 2015 Sales.

 

XERO

- Open XERO. 

- Select Reports and then Trial Balance. Date the Trial Balance as the last day of the month you want to Import. Sort by Account Name and export to Excel.

- Open the Excel trial balance and save as a CSV into a destination folder e.g. Demo Store October 2015.

 

ProStix

1. Create Trial Balance

- Open ProStix.

- Export Trial Balance data in CSV Format for the month required.

- Save ProStix CSV file with Store, Month, and Year, then move to a destination folder e.g. Demo Store October 2015 Sales.

 

Rees with GL

1. Creating Rees Export File

- Run Report 7.11.6.

- Selected required month.

- Use "File to desktop" function, this will save the file to your desktop in a .TXT format.

- When saving, select to include headings and totals.

- Rename Rees file with Store, Month, and Year and move to a destination folder, e.g. Demo Store October 2015.

 

Rees without GL

1. Sales

- Run 'Sales Totals per Month' report 4.11.19.

- To select particular period enter "1"-"12". "1" being April if using a March balance date.

- Enter "N" for print transaction for each code.

- Save Rees report file with Store, Month, Year, and Sales Totals, then move to a destination folder e.g. Demo Store October 2015 Sales Totals.

 

2. Expenses

- Run 'Cashbook Analysis Report" 8.11.7 for period.

- Save Rees report file with Store, Month, Year, and Sales Totals, then move to a destination folder e.g. Demo Store October 2015 Cashbook Analysis Report.

- To select a particular period press 1-12, 1 being April if using a March balance date.

 

3. Inventory

- Confirm value of debtors and inventory at month end if available.

 

4. Send - by end of following month

- Send the two reports and the inventory value by the end of following month to:

    support@otbs.co.nz