FrontAccounting Integration – Free Open Source Accounting Software & Transport Management System | worxTMS.com | Free Accounting Software for Transport Company | Free Transport Accounting Software | Free Accounting TMS Software | Free TMS Accounting Software

ℹ️ About FrontAccounting (Free Accounting Software for Transport Business)

FrontAccounting is a Free Accounting System for Transporters. worxTMS hosts FrontAccounting on our secure servers and provides integration support for transport companies. Our help focuses on getting the integration running, syncing invoices, and connecting transport data. For more advanced accounting setup or guidance, visit the FrontAccounting Official Website and community.

• FrontAccounting is hosted on our secure servers for convenience and reliability.
• Integration support includes connecting invoices, customers, drivers, and vehicles.
• Combine Transport Management System + Free Accounting Software for Transport into one integrated platform.
• Advanced accounting setup and configuration help is available on the official FrontAccounting website.
• Visit our FrontAccounting Demo Account: Username: FrontAccounting Password: T.B.A

🚧 In Progress

This page and integration is under active development. Soon, transport companies will be able to use FrontAccounting with worxTMS to manage invoicing, customers, drivers, vehicles, and carriers seamlessly.

Once the FrontAcc menu item appears, you can click it to access your FrontAccounting system directly inside worxTMS. All accounting features will be available here without needing a separate login.

Getting Setup: Setup >> Fiscal Years

Purpose

Fiscal Years are used to separate the accounting years from each other. A country's legal authority have various rules about how these Fiscal Years should be setup. A Fiscal Year often follow a normal Calendar Year, Jan 01 - Dec 31. But it could also be a broken year, f.i. Jul 01 - Jun 30. Many countries allow you to have an initial prolonged year, f.i. Jul 01 2009 - Dec 31 2010.

Procedure

Note that you create a new Fiscal Year by selecting Setup tab, Fiscal Years (you also close a Fiscal Year here) and you set the active Fiscal Year by selecting Setup tab, Company Setup.

When you start a new Company, you should check that the Fiscal Year is setup correctly. If this is not your starting Fiscal Year, then you should start by creating the starting Fiscal Year. After you have corrected the starting Fiscal Year, you can delete other Fiscal Years if there are no transactions in them. Now set this new Fiscal Year on your company by selecting Setup tab, Company Setup.

If the first year is setup as Jan 01 2011 - Dec 31 2011 and your starting Fiscal Year should be Jul 01 2011 - Jun 30 2012:

• Create a short dummy year, Jan 01 2012 - Jun 30 2012
• Create another Year Jul 01 2012 - Jun 30 2013
• Set the company to use this year
• Close and delete the year Jan 01 2011 - Dec 31 2011
• Close and delete the short dummy year Jan 01 2012 - Jun 30 2012
• Create the correct broken Fiscal Year Jul 01 2011 - Jun 30 2012
• Set this Fiscal Year Jul 01 2011 - Jun 30 2012 as active for the company

You are now ready to make your transactions. You have 2 fiscal years and you are using the current (Jul 01 2011 - Jun 30 2012) one, whilst the later one (Jul 01 2012 - Jun 30 2013) is not current.

• When you reach the end of your Fiscal Year, you have to create another new Fiscal Year.
• When you want to switch Fiscal Year on your company, go into company setup and do that.
• You will now be able to post to the current or past year:
  • Your document numbers will increase irrespective of the fiscal year you process in.
  • Change the process date to be in the correct fiscal year.
• When you have finished your year-end entries, you may close the Fiscal Year.
• A closed Fiscal Year can no longer be used for entries.
• When a Fiscal Year is closed, the difference between all asset and liability accounts are brought forward as a Journal Entry where the Default account for Retained Earnings is credited if this is a profit and debited if there is a loss. And the default account for Profit/Loss Year is debited if this is a profit, and credited if there is a loss).

You can have as many Fiscal Years running as you want, but for performance reasons you should not have more than needed (by your legislations). When you delete a Fiscal Year, the assets, liabilities and equities are brought forward. All other unneeded transactions such as documents are deleted.

Getting Setup: Setup >> Item Tax Types

We found that adding Taxable and Non Taxable makes sense! You can create multiple Item Tax Types depending on your country’s VAT/GST requirements. This setup lets you assign taxes only to items that require it while keeping others exempt. This simple structure helps transport companies quickly manage taxable vs. exempt items without confusion.

Getting Setup: Setup >> Tax Groups

Tax Groups in FrontAccounting allow you to bundle multiple tax rates together and assign them easily to customers or suppliers. For transport businesses, the simplest and most effective setup is:

• Taxable – applied to customers or suppliers that must pay VAT/GST.
• Tax Exempt – used for customers or suppliers exempt from tax.

This makes it easy to manage which transactions are taxable vs. exempt without needing to configure every invoice manually.

Note: According to the FrontAccounting wiki, Tax Groups define how multiple tax types apply simultaneously (e.g., state + federal taxes). While most transport companies only need Taxable and Exempt, you can expand groups if your region requires layered taxes.

Getting Setup: Setup >> Tax Types

Tax Types define the actual taxes (like VAT, GST, Sales Tax) that will be applied to your items, suppliers, or customers. Each Tax Type specifies the tax rate percentage and description. You can create as many Tax Types as needed depending on your country’s legal requirements.

• Example: VAT 15%, VAT 0%, GST 5%
• Tax Types are later linked into Item Tax Types and then grouped into Tax Groups.
• Each company can define its own set of Tax Types according to legislation.

For more details see the official FrontAccounting Tax Types Help Page.

Getting Setup: Banking and General Ledger >> Currencies

Currencies are managed under the Banking and General Ledger menu in FrontAccounting. This is where you define which currencies your company will use for transactions, and set the default home currency.

• Home Currency: Defines the base currency for your company’s books (e.g. USD, EUR, ZAR).
• Foreign Currencies: Add any other currencies you need to transact in with suppliers, customers, or bank accounts.
• Exchange Rates: Each foreign currency requires an exchange rate relative to your home currency. These can be updated as rates change.
• Inactive Currencies: If you no longer use a currency, mark it as inactive instead of deleting it (for historical data integrity).
• Transactions in foreign currencies will automatically be converted to the home currency using the exchange rates set here.

For full details see the official FrontAccounting Currencies Help Page.