@pingleware/bestbooks-reports

BestBooks Accounting Application Framework - Reports

There are no free options for creating reports from content received from a database. jsreports, jasperreports have limited free options.

Hence the report design will go back to basics,

1. creating an XML document for the data required for the report
2. display the XML using XSLT with CSS which can be printed or
   save as a PDF or DOCX (see https://www.geeksforgeeks.org/displaying-xml-using-xslt/)

During initialization (invoking the init() function)), will copy the xslt template files to the user's home directory in the bestbooks system directory.

The js2xmlparser package is used to convert an object to xml, while the xslt-processor package will transform the XML data and XSLT template to HTML format.

HTML can be converted to other forms like PDF.

Test Driven Development

When testing, run on a local system, as github workflows have issues with permissions and other problems that result in failure of the tests.

Reporting in Accounting

Reporting is the most important feature of any accounting system, because reporting permits the communication to interested parties. Using test driven development (TDD) allows the implementation of the reports module first.

GAAP Compliance

There is much discussion concerning GAAP compliance and accounting sofftware with some commentors stating that accounting software can never be GAAP compliance. First, GAAP compliance has to do with reporting and involves an accountant statement or notes added to the financial statements, this where the component noteToFinancialStatements permits the addition of a notes fields to the report XML data, thus making BestBooks GAAP compliance with the addition of a notes field on reports.

Also to ensure GAAP compliance, standard labels as defined by FASB should be used in the report generation. See FASB Segment Reporting (Topic 280), 2024 US GAAP Financial, SEC Reporting and DQC Rules Taxonomies with the updated link to FASB Explanatory Page

An exempt offering under Section 3(a)(11) which is an intrastate public offering issuing unrestricted securities to a single state bonafide residents. To ensure compliance of this exempt offering, segment reporting is required if the securities become traded on a NMS Exchange.

Reports included

You can customize the style of the reports by modifying the XSLT file located in the .bestbooks system directory of the current user home directory. The package XSLT files are ONLY copied to this directory if they do not exist. The available report XSLT files include,

account-payables-aging.xslt
account-receivables-aging.xslt
balance-sheet.xslt
breakeven-analysis.xslt
budget-vs-actual.xslt
customer-estimate.xslt
income-statement.xslt
income-statement-geographic.xslt
purchase-order.xslt
retained-earnings.xslt
statement-in-change-in-equity.xslt
statement-of-cash-flows.xslt
trial-balance.xslt

Account Payables Aging

Account Receivables Aging

Balance Sheet

Breakeven Analysis

Budget vs. Actual

Income Statement

Income Statement by Geography

Customer Estimate

Purchase Order

Retained Earnings

Statement in Change in Equity

Statement of Cash Flows

Trial Balance