FrontAccounting forum — Misc. Charts of Accounts

PCN Luxembourg 2021

null@example.com (gabriel.hauser) — Sun, 14 Nov 2021 22:08:06 +0000

Here comes the template for the "Plan comptable normalisé du Luxembourg 2021" in french.
German and english in preparation.

Objective: start a new company with the luxemburgish chart of accounts.
Not included: migration from any old/previously deployed CoA.

Copy paste the red sheets into the corresponding sql tables:
External download as *.ods File

Feedback or any request is welcome!

CoA Fiscal Year Discussion

null@example.com (apmuthu) — Sun, 04 Jul 2021 08:58:56 +0000

@kvvaradha: In FA v2.4.10, en_US-new has 2019 and en_US-demo has 2020. Both are outdated fiscal years, kindly update them and release it again.

@joe: I thought about that when releasing, However it is good to have at least one year back, so that in an eventuallty, a prolonged or deferred fiscal year can be created.

@kvvaradha: Ok. But we have to provide current year selection in the company setup and fiscal years. Those who comes to try new to our fa. They can't create invoice. Because of fiscal year is not new. New users may not know how to deal with it. Hope you understand the situation for the new users.

@rafat: I somehow tend to agree with @kvvaradha and would suggest that at least the demo version to contain the current fiscal year as the default so new users can navigate easily thru the system before they get into the serious stuff. I have some observations about the new Dashboard and would like to bring them out. Which section of the forum is most suitable?

@joe: Ok, I will update the COAs and commit and replace them at Sourceforge. Regarding observations, maybe FA Modifications or Report Bugs Here are suitable.

@apmuthu: Actually, a set of SET commands for a few date variables can be listed early in the sql dump and used everywhere whenever a fiscal year change is needed.

Agricultural accounting

null@example.com (msuhail197) — Wed, 05 May 2021 02:50:08 +0000

I want to use front accounting for agriculture farming accounting, Is it possible? It is produced by consuming different amounts of water and seeds and pesticides in different areas. How will the product of all these expenses be recorded in the FA?

Needed Temporary Customer Name and Contact

null@example.com (ksanthosh95) — Sun, 13 Sep 2020 16:26:47 +0000

Hi, I run Small level business, everyday i bill for 1000 to 2000 bills who buys goods from me, so i need a temporary field on direct invoice to enter customer name and contact.
please Help.

All charts updated

null@example.com (apmuthu) — Mon, 10 Aug 2020 04:41:16 +0000

All 41 charts have been updated with the new sys_prefs strings in my extensions repo.

ACCOUNT CODE ID

null@example.com (flopezcpa) — Sun, 26 Apr 2020 22:57:20 +0000

Hi, I want to change the Account Code 1 in the chart or Account and only I can to change the Account code 2, How I can Do its?

I have the Chart of Account for Panama, I want to send it to you.

I use Sage 50 US, but I want to use FA.

subclass of accounts

null@example.com (king1984) — Tue, 08 Oct 2019 17:44:05 +0000

You can create more than one subclass of accounts
Example

10 Sales Account
1012 Account for major customers
101213 Factories customers account
10121314 Store Customers Account
1012131412 Northern Region Customers Account

Chart of Accounts for Peru

null@example.com (gmarrufo) — Thu, 25 Apr 2019 22:41:03 +0000

Hi All,

Want to use FA in Peru, anybody has created a CA for that country? if so can I get a download and instructions on how to load it?

Thanks!,

Line 1369 in en_US-demo.sql can be removed

null@example.com (apmuthu) — Sun, 03 Mar 2019 16:34:10 +0000

@joe: Please check if line 1369 in en-US-demo.sql is necessary - it is dated in 2012:

('1', '0', '001/2012'),

There are many long char fields that should actually be varchar.
All AUTO_INCREMENT=XXX strings can be removed.

I want to export a chart

null@example.com (king1984) — Thu, 11 Oct 2018 13:50:54 +0000

I have a FA program and I want to export a chart of it how are you? Via phpmyadmin What are the names of the tables or the correct method that does not cause problems when working to have a transplant in another FA account

New Account under another account

null@example.com (emiangel839) — Fri, 05 Oct 2018 06:58:05 +0000

hey,
is there any option available for account already created under any head can be created sub head further.
e.g

Expenses -> Communication

This communication can be further divided like

Expenses -> Communication -> Phone
Expenses -> Communication -> Tell Phone
Expenses -> Communication -> Fax Phone

is it possible?

let me know about that

Charts of Accounts

null@example.com (whitetiger) — Sun, 01 Jul 2018 10:46:05 +0000

Is there a charts of Account for an Italian company?

sys_prefs flag ref_no_auto_increase added to all Chart of Accounts

null@example.com (apmuthu) — Sun, 22 Apr 2018 05:46:51 +0000

All Charts of Accounts in the FA24extensions repo have been updated with the new flag ref_no_auto_increase in the sys_prefs table data.

Auto Chart of Accounts Generator

null@example.com (apmuthu) — Fri, 16 Mar 2018 08:37:44 +0000

Committed the Auto Chart of Accounts Generator in my FA24Mods repo.

This generates the standard 4 digit CoA based on the en_US-new.sql file.

Upload the generated Chart to the sql folder and use it to create companies based on it.

Can also access it online.

This method can also be used to generate a skeleton for any new extension as well.

Can FA be set up for personal finances?

null@example.com (neiliob1973) — Tue, 06 Mar 2018 03:18:49 +0000

FA has SO many features...but does anyone have experience setting it up for home/personal finance use? I have a few people (including myself) that would like to keep both business and personal finances in one program (but as separate "companies").

Any words of wisdom?