The ERPNext Australian Localisation app will install the necessary localisation functionalities for Australian business in ERPNext. This app works in line with the Australian Chart of Accounts. The features of this app are as follows:
- Assist the Australian companies to get the GST postings based on the Supplier and Customer type (Local / International / Capital Goods / Non Capital Goods).
- Options for the companies to choose the method for BAS Reporting - Full reporting or Simpler Reporting.
- Generate the BAS report based on Full Reporting method with the amounts to be reported in each of the BAS Label (1A, 1B, G1 to G9 and G10 to G20).
- Generate the BAS report based on Simpler Reporting method with the amounts to be reported in each of the BAS Label (1A, 1B and G1).
- Payment Proposal functionality to match the Payment Run for local suppliers.
- Generate ABA (Specified by Australian Banking Association) file used to process electronic transactions for supplier payments through the internet banking system of Australian banks.
- Import of Bank Statements (CSV Format File) in the Bank Reconciliation function.
- ABN Number validation for Customer and Supplier.
ERPNext v16.0.0 or above
The AU Localisation app for ERPNext can be installed using the bench CLI:
cd $PATH_TO_YOUR_BENCH
bench get-app https://github.com/Arus-Info/ERPNext-Australian-Localisation.git --branch version-16
bench install-app erpnext_australian_localisation
- BAS Report can be generated based on either Simpler or Full reporting method
- Capital Goods & Non Capital Goods Supplier definition in the Supplier Master's Tax Category field
- Import Supplier definition in the Supplier Master's Tax Category field
- Domestic / Export Customer definition in the Customer Master's Tax Category field
- Exempt Item definition in the Item Master's Tax tab
-
- Sales amounts are reported in G1, G2 and G3 as per the Customer Tax Category definition
- Purchase amounts are reported in G10, G11 and G14 as per the Supplier Tax Category definition
- Input Taxed Sales and the corresponding Purchase recording to report in G4 and G13 BAS Labels
- Estimated Purchase for Private Use recording to report in G15 BAS Label
- Adjustments for Sales and Purchase to report in G7 and G18 BAS Labels
-
- Sales amounts are reported in G1 based on GL Entries.
- The final 1A and 1B label amounts will be reported to arrive at the amount business needs to pay the ATO or the amount ATO will refund the business
- BAS reports can be generated Monthly / Quarterly
- BAS reports (detailed information with transactional document number) can be printed in PDF format
- Payment Proposal (Batch) generation for Supplier / Employee Payment
- ABA File generation for the Payment Batch which can be used to upload into the online banking system for bulk payments for the suppliers / employees
When the new company is created, please select the chart of Accounts template "Australia - Chart of Accounts with Account Numbers".
For additional / new Australian companies in the existing system
Australian Localiation Workspace - Carries the basic instructions & the functionalities offered
AU Localisation Settings: The frequency of BAS report submission can be changed from Monthly to Quarterly only when there is no open BAS report is available in the system. Also the BAS Reporting Method (Full/Simpler) is defined on the below page.
In case of Simpler BAS Reporting method to be used, the Account setup for BAS labels are available in Simpler BAS Report Setup.
Glimpse of the BAS Report:
Simpler BAS Report
Full BAS Report
Printable format of the BAS Report - Please print in Landspcape orientation for better readability
Setup for ABA file generation:
Company Bank Account Setup - Below information are mandatory for ABA file generation
For every suppliers where ABA file needs to be generated, the below information are mandatory. The Lodgement Reference entered on the supplier master comes as default reference in the Payment Batch. But this can be overriden in the Payment batch.
Payment Proposal Functionality: This functionality is equivalent to Payment Run process to generate bulk payments. This functionality allows the user to filter the documents based on Due / Posting Date & the document created User.
Alternate option of creating a Payment Batch without using Payment Proposal functionality: Using this functionality, the Payment Batch is manually created and the Payments which are in Draft status can be pulled into the Payment Batch for ABA file generation.
ABA File generation functionality from the Payment Batch screen:
ABN Validation:
GUID setup – Below information is mandatory for ABN Validation for Customers and Suppliers.
To get the GUID for your company, please apply it in ABR – Australian Business Register using this link Click Here.
Enter the ABN number in the Tax ID field and click on save.
Once you have entered the ABN number in the Tax ID field, a Pop-up message will show the ABN Information. Click “OK”.
The above ABN information will be shown in both Customer and Supplier master.
Bank Statement (Compatible for AU Banks CSV format) Import Functionality:
Bank Statement format setup – Below information is mandatory for importing the Bank Statement into the system. Please select your Bank in the field shown below. Currently all the big four Banks’ statement format is compatible with ERPNext’s AU Localisation app.
Below is the sample screenshot from NAB to download the CSV format of the Bank Statement. Please use similar options to download the CSV format of the bank statement of your banking online portal.
Attach the CSV format bank statement file downloaded from the bank portal as detailed in the previous step
Once the attachment is imported, click on Start Import. This will convert the Bank statement CSV file to the ERPNext compatible format in the background and the transactions will be imported.
This project is licensed under GNU General Public License (v3)