You are welcome

You can create fiscal from Jan to Dec and 
Enter your existing account balance on 31 August in Journal Entry.

alternatively you can print report on General Ledger Reports -> List of Journal Entries.
just for my curiosity, why the journal have so many entries?

It's depend on how you set the tax system.
You can refer to:
https://frontaccounting.com/fawiki/index.php?n=Main.TaxSystem

All your mentioned accounts should be in old system balance sheet entries. The easier way is taking the old system balance sheet entries and enter into FA opening balance.

JV = Journal Entry?

1.   Dr Bank
          Cr Owner's Equity(Capital)

2.   Dr Owner's Equiry(Capital)
           Cr Bank

2) "the Description or Memo" is refer to person/memo?
It's no enough spaces to print all in A4 paper.
If you can leave out the dimension field on GL Report (rep704.php) change the memo column on 4 to 7,   $rep->TextCol(4, 7,    $txt, -2);
and remark the dimension (from line 162 on ver 2.4.8) as follow:

// Remove dimension
//if ($dim >= 1)
//    $rep->TextCol(4, 5,    get_dimension_string($myrow['dimension_id']));
//if ($dim > 1)
//    $rep->TextCol(5, 6,    get_dimension_string($myrow['dimension2_id']));
$txt = payment_person_name($myrow["person_type_id"],$myrow["person_id"], false);
$memo = $myrow['memo_'];
if ($txt != "")
  {
    if ($memo != "")
    $txt = $txt."/".$memo;
  }
  else
    $txt = $memo;
// Change memo on col 4 to 7
//$rep->TextCol(6, 7,$txt, -2);
$rep->TextCol(4, 7,    $txt, -2);

Hi, I am not from Philippines, but I don't think we need to getting permit from tax authorities to use any accounting system.
Your invoices and financial reports must compliant with the financial regulations in your country,
and this can be done by settings and modifying reports in FrontAccounting.

35

(3 replies, posted in Setup)

Should be the file and directory permission problem, pls refer to:
https://frontaccounting.com/punbb/viewtopic.php?id=4387

36

(2 replies, posted in Setup)

Hi, I have create a video on Singapore GST Accounting
https://youtu.be/OcNLxozI9Ms

Tax Compliance is the main concern of choosing accounting software,
hope my tutorial can help users on setting up the Tax system in FrontAccounting.
and please point out any mistakes I have make in video, thanks.

add the 2 statement end of while loop. (after line 226)

      if ($show_balance)
     $total[3] = $total[0] - $total[1];
     
     // display ref. on 2nd line  
      $rep->NewLine();                      
      $rep->TextCol(1, 2,$trans['reference']);

I think most users enter supplier invoice number in the supplier ref. field.
and usually supplier sent statement only include the invoice number,
for easier checking, It's good to include supplier ref in the Supplier Balances report (rep201.php)

If you know php, you can change the reporting/rep201.php in ver 2.4.8 is on line number 192
change $trans['reference'] to $trans['supp_reference']

        while ($trans=db_fetch($res))
        {
            if ($no_zeros && floatcmp(abs($trans['TotalAmount']), $trans['Allocated']) == 0) continue;
            $rep->NewLine(1, 2);
            $rep->TextCol(0, 1, $systypes_array[$trans['type']]);

Instalment sales is a complicated program, current no such extension available.
you may need to ask for customize this extension.

We enter customer name and address in customer maintenance main form only,
maybe I not understand your question.

You need to close the existing account and the balance sheet will be the opening balance in new FA accounting system.

you can refer to:
https://frontaccounting.com/fawiki/index.php?n=Main.OpeningBalances

or my YouTube Video, How to enter Opening Balances in FA:
https://youtu.be/Ka563SskUrg

41

(4 replies, posted in Reporting)

For total or grand total of quantity, you can change the Destination to Excel in report menu and
using sum function to get the total quantity.

42

(4 replies, posted in Reporting)

If you want to create your custom stock report you can refer to rep301.php (Inventory Valuation Report)

43

(4 replies, posted in Reporting)

Inventory Valuation Report.
Go to Items and Inventory->Inventory Reports->Inventory Valuation Report

Closing GL Transactions is used to lock the transactions to prevent entering new transactons up to specified date.
For example, accountant have done quarterly Tax report, he should close GL transactions to prevent new data that will affect the final tax report.
Closing a fiscal period is on Setup->Fiscal Years.

Hi jcnew, I have created 2 video about creating extension and reports.
hope these can help you.
https://youtu.be/t7znTMFvJvA
https://youtu.be/uj9QVCJQCv4

if your company manufacture not many different items, maybe you can create specific inventory a/c for each item.

Hi, are you asking where is the SQL statement located?
It is in includes/ui/ui_list.inc

I think you are referring to Profit & Loss statement.
in manual accounting, you have to enter all debit and credit entries for trial balance, P&L and Balance sheet.
in computerize accounting system, all GL entries are posted from Sales,purchases, Journal entries etc modules,and trial balance, P&L, Balance sheet reports are generated from GL.
Profit and Loss, Balance Sheet report requirement differ from all countries, companies and type of business, so either we output FA report to excel format and modifying from it, or customize the 2 reports.

Hi, I am only a FA user, those experts in accounting and FA please correct me if I am wrong.

In computerized accounting system, the Profit & Loss year a/c is mainly for keeping the profit or loss in the fiscal year.
I think what you mentioned P&L account is credit income debit expenses is for manual accounting system.
The COA in FA are template, you have to setup COA according to your country standard and company need.
The Romania COA should be wrong, just follow the FA standard, set Profit and Loss Year Account to Expenses class.

Sorry should be:
if (!is_account_balancesheet(get_post('retained_earnings_act'))
        display_error(_("The Retained Earnings Account should be a Balance Account ))
if (is_account_balancesheet(get_post('profit_loss_year_act'))
               display_error(_("The profit and loss should not be a Balance Account ))