FrontAccounting forum — Banking and General Ledger

How to change a bank account not in use to "inactive"

null@example.com (thorbjornw) — Mon, 09 Feb 2026 21:23:12 +0000

We have a bank account defined in the banking ledger which has not been in use for more than 10 years, and I try to change it to "inactive" but get the answer that this is not possible. Any other way to get rid of it?

Trial Balance error

null@example.com (solstice21) — Tue, 04 Nov 2025 20:13:10 +0000

Hi All
I have a trail balance question - on our year end the trial balance show one Asset Account opening at one number and closing at double. There are NO transactions to account for this and I cannot find anywhere that there would be an error. Anyone else had this happen and what was the issue - I am at a loss for where to look.

Bank Account Enquiry Screen Not Showing Memo Data

null@example.com (david.pettigrew) — Mon, 03 Nov 2025 18:14:29 +0000

Hi,
I'm new to FrontAccounting and only need to use the General Ledger. I'm really impressed with it and have managed to import from Sage 50 a custom chart of accounts, several years of transactions and I also have 1 dimension set up as departmental cost centers. All working fine and reconciling with my Sage system which I want to ditch at the end of the tax year.

I'm using Version 2.4.18 Build 03.04.2024 on Linux Mint with a local Apache server and MySQL database.

One issue I do have is when I make a Bank Account Inquiry. Any memo information I have input at the transaction line entry level does not show up on the screen. The field is there but it's blank. If I click on the book icon, the memo information is shown on the resulting screen.

Looking in the database, there does not appear to be a memo field in the bank trans table but it is there (with the corresponding memo data) in the gl trans table for the same transaction.

Am I missing something or is this a bug?

Who do you use for employee health insurance and benefits?

null@example.com (Stotle) — Tue, 05 Aug 2025 20:36:58 +0000

We need to set up health insurance and some basic benefits for our team. Nothing over the top, just solid coverage and maybe options like dental or vision down the line. I came across TaylorBenefits while browsing, but I’d love to hear if anyone here has worked with them or found another company that’s been a good fit. We’re a small team, so flexibility and easy communication matter a lot. Any recommendations?

"Closing GL Transactions" grayed out

null@example.com (alex1452) — Fri, 27 Jun 2025 02:55:48 +0000

Hi Forum,

I am trying to switch from another accounting software to FrontAccounting. I have done 2023 in the other accounting software and would like to do 2024 in FrontAccounting.

In order to have the right starting balance in FrontAccounting, have created a new GL 3999 Opening Balance Equity and created journal entries for 12/31/2023 to book all positions of the Balance Sheet from the other accounting software. The Profit of 2023 is booked to 3590 "retained earnings". I have reconciled all bank accounts simply by using 0 as starting balance and the actual YE balance as ending balance. I am "System Adminstrator" working on a fresh installation of 2.4.18 with the default US-COA.

I would like to close now 2023 to start posting actual transactions for 2024. However the menu item "Closing GL Transactions" is grayed out. None of the journal entries that I have created for 12/31/2023 is closed. Why is "Closing GL Transactions" grey and what do I have to do to close the "dummy" 2023 to start working on 2024?

Thank you for your help!
alex

GL Inquiry can't show one year of data

null@example.com (DrCard) — Thu, 19 Jun 2025 08:13:37 +0000

When I try query one year using the gl inquiry in my database using one of my accounts which have ~16000 transaction in 2024 the page stuck like what shown in the picture at the attachment and no result given.

How can I let FA give me the result I'm running FA in server with 8GB of ram using RHEL 9 based distro using nginx and php 8.3.

Sorting of Expense Accounts Alphabetically

null@example.com (seahawk) — Thu, 01 May 2025 19:45:39 +0000

Is there a way that one can sort the Expense Accounts Alphabetically instead of Account Numbers?

Import Transactions

null@example.com (blhelm) — Fri, 18 Apr 2025 13:56:06 +0000

I've been using "Version 2.4.5 Build 16.03.2020" since 2016 on a computer running an End of Life version of Linux. I recently built a new computer with a more recent version of Linux and installed "Version 2.4.18 Build 03.04.2024" of FA. I exported the entire database from the old computer and imported it into the new one using PHPAdmin. Everything seemed fine.

However, when I attempt to "Import Transactions" the "Import Settings" screen will not changes the "Control Accounts" when switching the "Import Type" (drop down list) from "General Journal Processing" to any of the following:
- Deposit Processing
- Payment Processing
- Sales Order Processing
- Direct Sales Invoice Processing

Instead, it continues to show "Receivable Account Default" and "Payable Account Default"

showing double values

null@example.com (nazirsayedquli) — Wed, 16 Apr 2025 13:47:03 +0000

Banking and General Ledger dashboard FrontAccounting (FA) is showing double values for "Today's Deposits" and "Today's Payments" (e.g., 100 entered but 200 shown)

Add credit card as bank account

null@example.com (bookworm) — Fri, 28 Mar 2025 15:29:20 +0000

Hello,
Is there a step by step process to add a credit card as bank account and liability account.
I understand the theory of paying a supplier with a credit card and then transferring funds to pay the credit card as described in the wiki and forum posts but when I try to add a new account in FA I just get a flicker on the screen and then nothing changes.
I enter a new unused account number so previous transactions are not an issue.
Do I have to make these changes in my COA.sql file or is there a way to do it from the FA interface?
I am using FA 2.4.18.

Inventory Adjustment GL Account

null@example.com (popsicles12) — Thu, 16 Jan 2025 11:41:48 +0000

Good day all,

I am helping someone to setup Frontaccounting for his small business.

I am entering his opening inventory and I used Inventory and the Inventory Adjustment GL for the Items. Now after entering the Inventory its showing NIL. As I check the GL transaction, debit & credit is Inventory.

Please which account do I use as Inventory Adjustement GL. Do I create one or use the Purchase Price Variance that is used as default by FA.

thanks

Popsicles12

The Opening Balance is not in balance

null@example.com (tom) — Sat, 04 Jan 2025 15:05:05 +0000

I likely made a mistake when I started this new company...

I was looking at 2024 Trial Balance and get the message

The Opening Balance is not in balance, probably due to a non closed Previous Fiscalyear.

This is the First year... BUT I made it by deleting previous years from my store, it just change ownership structure

The non-zero values in the BROUGHT FORWARD are Checking Accounts, Receivables, Inventory, Sales Tax Liabilities (from previous year)
and loans from shareholders... oops the last one I may need to void out

So since I am explain all these, then it is ok and I should not have to worry about it in the future?

I also noticed that I have some open balances that should have been $0
There were no transactions against that, so I was wondering if I could edit the Opening balance to 0

Tom

GL account cannot be inactivated

null@example.com (Rafy) — Fri, 11 Oct 2024 12:14:47 +0000

It is not possible to declare a general ledger account as inactive, while a bank account is linked to this GL account. Even if the bank account itself is declared as inactive in "Bank Accounts" (tick box).
In the above described case the following message is shown when trying to set the GL account as inactive: "The account belongs to a bank account and cannot be inactivated."

Is there a work around how to set a general ledger account linked to a bank account as inactive?

Version used: 2.4.16

Thanks and regards
Rafy

Support CryptoCurrency as a Asset/Currency Account

null@example.com (tom) — Mon, 07 Oct 2024 10:52:25 +0000

One aspect of my business is to perform cryptocurrency mining (Proof Of Work) generating income as an asset.

How could we manage this type of ledger?

Generally Crypto is considered an Asset and POW coins more so since they can not be minted (created) out of thin air.

My first thought is they are very much like an Inventory Item (Physical Asset) that has an account (GL?) tracking the realized value.

For example if I earn 20 coins while the value (price) is $0.50 the value/income if $10.00
If I sell 5 coins at $1.50 that would obviously be an additional $5 of income and I think typically the income would be calculated on the oldest unsold coins, First In, First Out

So at this point we have $15 of income and a current asset value of (20-5)*1.50 = $22.50 with Unrealized gains of $15.00

Are my thoughts on this reasonably accurate?

I think these point are common to all localities, but the calculation of Long/Short Term Gains would be left to tax calculations

I am not looking to pay someone to do this, but could use some help.

I do not believe such a fundamental feature qualifies as an add-on that is sold.

So I am asking for anyone who has the skills to do it contribute their time which is the whole point of open source.

Supporting Crypto will help keep FA relevant and I do not think these changes will be overly dramatic to implement.

Anyone interested in working with me?
--
Tom

PS
I have been using FA for over 15 years and have submitted every modification I needed for my shop as either a patch or extension.

For example:
Bank Fees on customer payments
osCommerce customer/order import extension

I am currently working on a WooCommerce order import extension which I will make freely available in the core FA repo

My son and I are also deploying FA as a turnkey application on Flux Web services (runonflux.io) which is a distributed compute network on a blockchain

Change of Ownership - Delete past years

null@example.com (tom) — Wed, 21 Aug 2024 10:28:42 +0000

I have been using FA for a business since 2010 and the ownership has changed from a single owner to LLC

I want to delete the past years and reset the GL accounts to 0

I assume the first step is to delete all previous years

Wow that was easier than I thought...
I do see some some balances that are wrong, but just deleting the years did most of what I wanted

Maybe not so much wrong... but I did find I could not delete long gone bank accounts.
It seems what FA 2.4.6 I was able to create more than one 1060 bank account...

I may need advice on how to remove the extra ones

Tom