https://www.youtube.com/watch?v=Bw-ax5BjwCo
1 03/31/2025 08:03:57 am
Re: Add credit card as bank account (3 replies, posted in Banking and General Ledger)
2 03/31/2025 08:02:38 am
Re: Add credit card as bank account (3 replies, posted in Banking and General Ledger)
Using https://www.perplexity.ai we ask:
FrontAccounting add a credit card as bank account and liability account
and we get
To add a credit card as both a bank account and a liability account in FrontAccounting, follow these steps:
Steps to Add a Credit Card as a Bank Account and Liability Account
Create a General Ledger (GL) Liability Account:
Navigate to the Banking and General Ledger section.
Create a new GL account specifically for your credit card under the liability category. This will represent the amount owed on the credit card.
Set Up the Credit Card as a Bank Account:
In the same section, create a new bank account.
Link this bank account to the GL liability account you just created. This allows transactions made with the credit card to be tracked properly within your accounting system.
Enter Supplier Details:
When making payments to suppliers using the credit card, ensure that you select this newly created bank account during the payment process. This will register the transaction against the credit card liability account.
Record Payments to the Credit Card:
When you need to pay off the credit card, perform a bank transfer from your main bank account to this credit card bank account. This transaction will reduce your cash balance and reflect a decrease in your credit card liability.
Ensure No Existing Transactions:
Make sure that the GL account you are linking has no existing transactions before associating it with the bank account. If there are existing transactions, you may encounter errors when trying to link them
.
By following these steps, you can effectively manage your credit card transactions within FrontAccounting, ensuring that both your liabilities and cash flows are accurately represented in your financial records.
3 03/31/2025 07:04:55 am
Re: Downloaded Files are Corrupted (1 replies, posted in Jobs wanted/offered, non-free offers)
Provide the exact text of the error message.
4 03/31/2025 07:03:54 am
Re: Extensions NOT Activating (1 replies, posted in Modules/Add-on's)
Check the version numbers of the extensions and those in both the modules folder and those in the installed_extensions.php fil in both the FA root and in the company folders.
5 03/05/2025 10:06:11 am
Re: Direct Invoice not processing (2 replies, posted in Setup)
Looks like the way NULL is checked in the next line.
Try the next line:
if ($type != NULL) {
as
if ($type != NULL || $type != '') {
Also check if it runs okay with PHP 7.x.
6 02/27/2025 05:07:31 pm
Re: WordPress (23 replies, posted in Modules/Add-on's)
https://wordpress.org/latest.zip
https://wordpress.org/wordpress-6.7.2.tar.gz
https://downloads.wordpress.org/plugin/woocommerce.9.7.0.zip
7 02/26/2025 10:35:52 am
Re: New account creation problem (6 replies, posted in Report Bugs here)
huzaziz2@gmail.com is now officially created.
8 02/26/2025 10:22:48 am
Re: New account creation problem (6 replies, posted in Report Bugs here)
https://imgur.com is banned in India and quite a few countries.
Could be a local DNS resolution issue.
The official IPs for the said domain are:
199.232.192.193
199.232.196.193
Even archive.org is banned in India and only recently distrowatch.com has been re-enabled.
9 02/26/2025 10:17:44 am
Re: WordPress (23 replies, posted in Modules/Add-on's)
Which version of WP does it work / not work?
10 02/15/2025 03:05:04 pm
Re: module_info.inc not used in extensions (2 replies, posted in Modules/Add-on's)
Perplexity.ai seems to do a good job for FrontAccounting:
import items into FrontAccounting
11 02/14/2025 04:05:28 pm
Re: module_info.inc not used in extensions (2 replies, posted in Modules/Add-on's)
Tried DeepSeek for answer to creating Extension for FrontAccounting. Attached results. It is wrong to state that module.php is required in the extension.
12 02/13/2025 06:47:33 pm
Topic: ClientInfo file to be modified (0 replies, posted in Installation)
https://frontaccounting.com/wbt/media/download_gallery/clientinfo.zip
The file test_cl_info.php should be modified from:
<?php
/**********************************************
Author: Joe Hunt
Name: Test Client Info
Free software under GNU GPL
***********************************************/
$page_security = 3;
$path_to_root="../..";
.....
to
<?php
/**********************************************
Author: Joe Hunt
Name: Test Client Info
Free software under GNU GPL
***********************************************/
$page_security = "SA_OPEN";
$path_to_root="./";
.....
and placed in the FA application root.
13 02/13/2025 06:20:22 pm
Topic: module_info.inc not used in extensions (2 replies, posted in Modules/Add-on's)
All new extensions in FA 2.4 do not use the file module_info.inc at all.
ChatGPT has got it wrong.
14 02/13/2025 04:44:56 pm
Re: AI ChatGPT for FA - How to configure Indian Tax (2 replies, posted in Setup)
ChatGPT answers: How to create a new module in FA?
Also refer https://www.flpages.com/2020/07/frontaccounting-customization.html
15 02/12/2025 11:31:31 am
Re: AI ChatGPT for FA - How to configure Indian Tax (2 replies, posted in Setup)
https://www.perplexity.ai
Ask Perplexity AI:
How do I setup Malaysian Sales Tax in FrontAccounting?
Perplexity AI:
To set up Malaysian Sales Tax (SST) in FrontAccounting, you need to configure taxes, tax groups, and item tax types1. Here's a step-by-step guide:
: Create a new account for import tax (e.g., 2151) and classify it under current liabilities16.
: Configure the tax rates used for Item Tax Types and Tax Groups1.
: Set tax rates for different customer groups, such as domestic or export sales1. To access this, go to Setup tab and select Access Setup. Enable Tax Groups under the Banking & GL Config heading1.
: Define groups of tax rates applicable to specific goods sold. Item tax types contain all tax rates that are not explicitly exempted1.
:
Ensure you have an Accrued Account for tax collection to avoid booking payments directly against the Tax Accounts1.
Enter a Journal Entry (JE) to clear the Tax Accounts and transfer the balances to the Accrued Tax Account at the end of the reporting period (e.g., monthly)1.
When you pay the tax via Bank Payment, debit the Accrued Tax Account and credit your bank account1. If you receive a tax refund, use Bank Deposit and book the transaction accordingly1.
:
: In Sales => Sales Types, if the Tax included box is checked, FrontAccounting assumes that tax is already included in the item price and will not display tax on sales orders or invoices1.
: To include multiple taxes on a single invoice, define the respective percentages in the settings module. Then, go to tax group and select the default customer tax group and click the check boxes in tax section to include multiple tax1.
: Ensure a branch record is created for each customer, either automatically or manually, as taxation depends on where the real business activity is performed, which is selected at the branch level1. The switch $auto_create_branch in config.php determines whether branch records are created automatically1.
: To report taxes, run the Tax Report within the FrontAccounting system for the relevant period1. The Tax Transaction Details are stored in the trans_tax_details table1.
:
: The current sales tax in Malaysia ranges from 5% to 10%. A rate of 5% is applied to products like milk, dairy, and prepared foods, while a 10% rate applies to goods like sugar, spirits, and electrical appliances3.
: In the Malaysian context, the Item Master should be the basic tax setting, configured for both Input and Output Tax Codes2.
: Sales Tax invoices must include specific information such as the invoice serial number, date, registered manufacturer details, buyer details, description of goods, discounts, taxable amounts, tax rates, and total amounts in Ringgit Malaysia (MYR)4.
16 02/12/2025 11:27:35 am
Topic: AI ChatGPT for FA - How to configure Indian Tax (2 replies, posted in Setup)
Use ChatGPT to support FA for your users:
Go to https://www.chatgpt.com
Type in:
How do I configure GST for India in FrontAccounting application?
ChatGPT said:
Configuring GST for India in FrontAccounting involves a few steps to ensure that the application is set up correctly to handle GST (Goods and Services Tax) for transactions. Follow these steps:
1. Set Up GST Tax Categories
In India, there are different GST rates, such as 5%, 12%, 18%, and 28%. These need to be set up in FrontAccounting.
Navigate to the "Taxes" section in the application:
Go to "System" → "Taxes" → "Tax Categories".
Add the different tax categories that correspond to the Indian GST rates. You will typically need categories like:
GST 5%
GST 12%
GST 18%
GST 28%
IGST (for interstate transactions)
In each tax category, specify the percentage rate and whether it’s CGST, SGST, or IGST.
2. Set Up GST Accounts
You'll need specific accounts for GST purposes to track the collection and payment of GST, as well as Input and Output GST.
Navigate to the "Chart of Accounts":
Go to "Accounts" → "Chart of Accounts".
Create separate accounts for:
GST Output (Sales GST) – For the GST collected on sales.
GST Input (Purchase GST) – For the GST paid on purchases.
CGST, SGST, and IGST – If you need separate accounts for each type of GST (this is necessary for compliance).
3. Configure Tax Calculation Method
Next, you need to configure the tax calculation method for your items and services.
Navigate to "Items" → "Item Master".
Add your inventory items or services with the appropriate tax category for GST.
Select the tax category for each item (5%, 12%, 18%, etc.), depending on the GST rate applicable to the product/service.
FrontAccounting will use these settings to calculate GST during invoicing.
4. Configure GST on Sales and Purchases
Make sure that GST is applied correctly when creating sales and purchase invoices.
Sales Invoice:
When creating a sales invoice, select the correct GST tax category for the items sold.
The system will automatically calculate and display the GST based on the rate configured for each item.
Purchase Invoice:
Similarly, for purchase invoices, ensure you select the correct GST tax category to record the GST paid.
5. Configure GST Reporting
To file GST returns, you’ll need to generate GST reports.
GST Return Report:
FrontAccounting can generate reports to show sales and purchases with GST details.
Go to "Reports" → "Tax Reports" → "GST Report". This will give you a breakdown of the tax amounts for your records.
You can generate GST Summary or GST Detail reports that help you with tax filings.
6. GST Filing Period
Ensure that the fiscal year in FrontAccounting is set up to match India's GST filing cycle (monthly or quarterly). You can specify the dates for each period as required.
Additional Tips:
GST Invoices: Ensure the GST numbers (GSTIN) are added to invoices, especially for inter-state transactions.
Tax Adjustment: If you need to adjust tax amounts, FrontAccounting provides options to modify tax rates for specific transactions.
If you're unsure about specific GST requirements, consult with a local tax professional who understands the nuances of India’s GST system.
17 02/11/2025 08:56:49 am
Re: Route Deliveries plugin has been updated (1 replies, posted in Modules/Add-on's)
Thanks. Committed
19 02/09/2025 03:42:03 pm
Re: WordPress (23 replies, posted in Modules/Add-on's)
Wonder what the line for SHA1sum is in the _init/config file ?
As I have added woo_orders to my repo the pull request was not needed now.
20 02/06/2025 08:06:00 pm
Re: WordPress (23 replies, posted in Modules/Add-on's)
Unofficial Extensions repo:
https://github.com/apmuthu/FA24extensions/tree/master/Extensions/woo_orders
21 01/18/2025 06:22:11 pm
Re: Inventory Adjustment GL Account (1 replies, posted in Banking and General Ledger)
All opening balances in amounts are made through a journal entry that is balanced. All inventory opening balances too can be done through a dummy sales / purchase account that can be settled as paid/received onto the suspense account in a balanced manner. Mere creation of stock on hand will not have its value balanced off.
22 01/18/2025 06:19:10 pm
Re: 504 Gateway Timeout (12 replies, posted in Installation)
PHP / MySQL vagaries in encoding and function constructs and crypto hashes and some function definitions and rounding off errors besides Apache versions
23 01/15/2025 01:27:47 am
Re: 504 Gateway Timeout (12 replies, posted in Installation)
Please make sure that any master changes have compatibility with Windows as well.
24 01/13/2025 07:12:48 am
Re: Costed Inventory Movements (2 replies, posted in Reporting)
Costing method used can be stated in the report.
25 01/13/2025 07:08:29 am
Re: 504 Gateway Timeout (12 replies, posted in Installation)
Lines 416 and 481 have both parameters in admin/db/maintenance_db.inc
Also in the CoA sql/en_US-new.sql we have SET NAMES latin1; and it may be utf8 for other language CoAs.
Please list the changes you have made.