BrightBooks offers the following general ledger reports. You can generate the reports by specifying one or more criteria.

Note that the period or time ranges the reports allow you to specify by default starts with the first month of the year and ends with the last month of the year. For example, the period from starts with Jan-2018 while the period to ends with Dec-2018.

• Trial Balance
• Formatted Trial Balance
• P&L Report
• Balance Sheet Report
• General Ledger Account Details
• VAT Return
• VIES Details
• General Ledger Account Activity
• Intrastat Details
• Return of Trading Details
• Periodic P&L Report
• Periodic Trial Balance
• Journal Listing
• Yearly Budget Comparison
• Periodic Budget Comparison
• Budget Details
• Audit Trail Report

Trial Balance

The report generates the trial balance for the specified financial year. You can generate the report for the current, past and comparative periods. To generate the report, complete the following steps.

• Log in to BrightBooks. The Business page appears.
• On the Business page, locate the required business by completing either of the following steps.
  • • In the Search box on the top right corner, enter the name of the business fully or partially and click the search icon. The business summary will appear under the Select a Business heading.
    • The business summary is available under the Select a Business heading. If you cannot find it, at the bottom-right corner of the page, click 100 to increase the number of records to be displayed on the page. The business summary will be available under the Select a Business heading.
• Under the Select a Business heading, click the name of the business.
• The Customers page appears. In the left panel, click Reports.
• The Reports page appears. On the Reports page, under the GENERAL LEDGER heading, click Trial Balance.
• The Trial Balance Report page appears. On the Trial Balance Report page, enter the required criteria and click [Run].
• You can add more columns to the report by clicking [Advanced Settings] and then from the Advanced Settings window, selecting columns such as Division and Subdivision.

  If, at the time of setting up the business, you select options Primary School or Secondary
   Schools, then in the Advanced Settings window, the column name IE/Balance Sheet will be 
  displayed instead of PL/Balance Sheet.

• The report data is displayed.

Formatted Trial Balance

• The report generates the profit or loss or balance sheet, depending on your choice. To generate the report, complete the following steps.
• Go to the Reports page.
• On the Reports page, under the GENERAL LEDGER heading, click Formatted Trial Balance.
• The Formatted Trial Balance Report page appears. Enter the required criteria. The report is generated based on the criteria you have specified.

FIELD	STEP
	Click and select a pre-configured date range.
PERIOD FROM	Select the period from which you want to view the report. You can set the date up to 5 years beyond the current set accounting period.
PERIOD TO	Select the period till which you want to view the report. You can set the date up to 5 years beyond the current set accounting period.
TYPE	Based on whether you want to view profit and loss or balance sheet, select the appropriate option. To view both, select Both.

• Click Run.
• The report is displayed. The profit and loss figures are shown against respective nominal codes while the balance sheet is against respective banks.

P&L Report

• This report displays the profit or loss in the form of variance from the budget against various nominal codes. You can also view the sales figures against divisions or subdivisions, if you have set any.To generate the report, complete the following reports.
• Log in and click the required business.
• The Customers page appears. On the left panel, click Reports.
• The Reports page appears. Under the GENERAL LEDGER heading, click P&L Report
• The P&L Report page appears. Enter the required details and click Run.
• The report is generated.

You can select the period up to 5 years beyond the current accounting period.

Balance Sheet Report

• To generate the balance sheet report, complete the following steps.
• Log in and click the required business.
• The Customers page appears. On the left panel, click Reports.
• The Reports page appears. Under the GENERAL LEDGER heading, click Balance Sheet Report.
• The Balance Sheet Report page appears. Enter the required details and click Run.
• The report is generated.

General Ledger Account Details

• This report generates the general ledger account details of a business based on your choice of nominal codes and a time period. For example, you could choose to view the report between March and April between a range of nominal codes.
• On the Reports page, under the GENERAL LEDGER heading, click General Ledger Account Details.
• The Account Details page appears. On the Account Details page, enter the required criteria and click [Run].

The report is generated.

The report generates clickable document numbers, shown in the image above. To move to the 
original document, click the document number.

VAT Return

• This report generates the VAT returns during a specified period.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click VAT RETURN.
• The VAT Return page appears. On the VAT Return page, enter the required criteria and click [Run].
• The report is generated.
• The financial report will generate reports regarding VAT Report, Bank Reconciliation, Trial Balances, Profit and Loss and Balance Sheet, Account Details, Journal Listing, Yearly Budget Comparison, Periodic Budget Comparison and Budget Details.

VIES Details

• This report generates the VIES details for a period. To generate the report, complete the following steps.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click VIES DETAILS.
• The VIES page appears. On the VIES page, enter the required criteria and click [Run].
• The report is generated.

General Ledger Account Activity

This report generates the general ledger account details of a business based on your choice of nominal codes and a time period. For example, you could choose to view the report between March and April between a range of nominal codes.

1. On the Reports page, under the GENERAL LEDGER heading, click General Ledger Account Activity.

2. The General Ledger Account Activity page appears. Enter the required criteria and click [Run].

3.  The Advanced Settings takes into account Future Opening Balances and displays it as Balance Forward in the General Ledger Report that is being published.

4. Under Advanced Settings, a new feature Page Break has been added. This feature provides a page break in the list of the generated report. The page break introduced becomes visible every time a generated report is printed or imported.

5. The report is generated.

The report generates clickable document numbers. To move to the original document, click the 
document number.

For Charity Template
In the Advanced Settings window, under Column Order, three new fields are added namely,
Fund Code, Cost Code and Activity Code. By default, these three fields will remain in the 
Exclude section and can be included as per requirement.
The Sorting List 2 also has the three fields Fund Code, Cost Code and Activity Code added.

Quick Print
On the General Ledger Account Activity page, click Quick Print to view an HTML version of the
generated report. To print this HTML version, right click on the screen and click Print.

Intrastat Details

• This report generates the VIES details for a period. To generate the report, complete the following steps.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click Intrastat Details.
• The Intrastat page appears. On the Intrastat page, enter the required criteria and click [Run].
• The report is generated.

Return of Trading Details

• BrightBooks has designed VAT Return of Trading Details Report (RTD) for businesses (businesses should be registered with location: Ireland) registered in Ireland. Irish Businesses need to furnish VAT Return of Trading Details Report to the Revenue department annually. BrightBooks RTD report matches exactly with the RTD format provided by the Revenue department on their website. We have designed the Return of Trading report as a one-click solution for users to dynamically deduce the Return values accurately at any point of time of the accounting period, thus reducing the calculation overhead of accountants. To generate the report, complete the following steps.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click Return of Trading Details.
• The VAT Return of Trading Details Report page appears. On the Intrastat page, enter the required criteria and click [Run].

Return of Trading Report

• Irish Businesses are required to submit a return of Trading Details Report to Irish Revenue department annually. The RTD report designed by BrightBooks facilitates user to generate auto-calculated report ready for submission. The transactions included in the report depend on the following criteria.
• The basis of VAT calculation: Cash or Invoice.
• The nominal codes defined as Goods/ services for Resale.
• The country of the trading customer/ supplier. ( depending on EU, non-EU, or Irish country, the value of the return will accordingly appear in specific cell of the RTD).
• Before you start adding business transactions, make sure that you have set up the VAT basis of calculations. To setup VAT basis, go to Settings, then select Accounts » Setup.
• As you setup VAT basis, please note that BrightBooks provides a set of default VAT rates within each business for users to apply with a specific purpose. Go to VAT settings option, to view the available VAT rates.
• The VAT rate X implies exempted from VAT. While adding customers and suppliers in a business, set the default VAT rate as X (which means this customer is exempted from VAT rate, so net vat rate applicable is zero percent) if you are sure of exemption.
• The VAT Rate N means non Vat –able. If products or customers/ suppliers are non-vat –able select the VAT for the particular customer/ supplier.
• The VAT Rate Z means zero VAT. Select this VAT if the VAT applicable for customer, supplier or product is zero.
• The next step of generating RTD report is to assign purchase nominal codes for resale of goods and services. BrightBooks defaults code 112 as default resale code. To add more codes, you can simply go to Accounts >> Chart of Accounts. Select a nominal code. Select the open option from the tool bar. Click the Advanced section; select the check box ‘Goods/ Services for Resale’.
• Add the customers and Suppliers in your business and specify their country of Trade and default VAT code of trade. The country of trade for customers/ and suppliers are important for the business as it defines your VAT return policies on sale, purchase, and resale of goods and services.
• The following example elaborates how RTD report reflects value in the respective cells: A customer TER001 is created with a country other than the European Union. The vat rate is set to x%. Receipt of Rs 450 is added against an Invoice of Rs. 301.86. On the unallocated amount, a VAT of 23% is applied on the gross of 100 and 13.5% on the gross of 48.14. The amount 301.86 is VAT exempted.
• To generate RTD Report in BrightBooks , go to Reports option, select Return of Trading Details Report.
• In the filter option, Select Start month, Start year and End month of the end year to generate the report.

Periodic P&L Report

• The report generates the periodic or month-wise profit and loss. To generate the report, complete the following steps.
• Log in and click the required business.
• The Customers page appears. On the left panel, click Reports.
• The Reports page appears. Click More Reports.
• Under the GENERAL LEDGER heading, click Periodic P&L Report.
• The Periodic P&L Report page appears. To generate the report, specify the criteria.
• The report is generated.

Periodic Trial Balance

• This report shows two different outputs based on your selection of the Business Type at the time of setting up the business. If you select Primary School or Secondary School as the business type, the heading of the report is shown as Periodic Balance Sheet Report by default. Else, it shows Periodic Trial Balance Report in the heading. The report outputs are also different for the selections. For Primary School or Secondary School business types, it shows the income and expenditure and the balance sheet in various banks across different periods while, for the remaining business types, it shows the profit and loss and the balance sheet summary. The steps to generate the report are shown for both approaches.
• Non-School Business Type
• On the Reports page, under the GENERAL LEDGER heading, click Periodic Trial Balance.
• The Periodic Trial Balance page appears. On the Periodic Trial Balance page, enter the required criteria, as given below and click [Run].

• The report is generated.

School Business

• On the Reports page, under the GENERAL LEDGER heading, click Periodic Trial Balance.
• The Periodic I&E Report page appears.
• On the Periodic I&E Report page, enter the following details and click Run.

Journal Listing

• This report lists journals during a period you specify. To generate a report, complete the following steps.
• On the Reports page, under the GENERAL LEDGER heading, click Journal Listing.
• The Journal Listing page appears. On the Journal Listing page, enter the required criteria and click [Run].

FIELD	STEP
	Click and select a pre-configured date range.
DATE FROM	Specify the date from which you want to view the report. You can set the date up to 5 years beyond the current set accounting period.
DATE TO	Specify the date till which you want to view the report. You can set the date up to 5 years beyond the current set accounting period.
ACCOUNT CODE FROM	Specify the nominal code from which you want to view the report.
ACCOUNT CODE TO	Specify the nominal code till which you want to view the report.

• Optional Step
• You can sort the report by the fields Doc No. and Ref No. fields. To sort, click Advanced Settings.
• The Advanced Settings window appears. Move the fields Doc No. and Ref No. under the Include heading and under the SORTING heading, select Doc No. and Ref No.
• A new feature has been added that has brought the presence of Disallowed for Tax under Features and the Column Order.
• Click Update.
• The report is generated and is sorted under the Doc No. and Ref No. fields.

Yearly Budget Comparison

• This report compares the actual figures with that of the budget during a specified period based on nominal codes specified. To generate the report, complete the following steps.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click Yearly Budget Comparison.
• The Yearly Budget Comparison Report page appears. On the Yearly Budget Comparison Report page, enter the required criteria and click [Run].

FIELD	STEP
	Click and select a pre-configured date range.
PERIOD FROM	Specify the period from which you want to generate the report.
PERIOD TO	Specify the period till which you want to generate the report.
ACCOUNT CODE FROM	Specify the nominal code from which you want to generate the report.
ACCOUNT CODE TO	Specify the nominal code till which you want to generate the report.

• The report is generated.

Periodic Budget Comparison

• The report does a comparison of the differences between actual and budgetary figures based on nominal codes specified. To generate the report, complete the following steps.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click Periodic Budget Comparison.
• The Yearly Budget Comparison page appears. On the Periodic Budget Comparison page, enter the required criteria and click [Run].

FIELD	STEP
	Click and select a pre-configured date range.
PERIOD FROM	Specify the period from which you want to generate the report.
PERIOD TO	Specify the period till which you want to generate the report.
ACCOUNT CODE FROM	Specify the nominal code from which you want to generate the report.
ACCOUNT CODE TO	Specify the nominal code till which you want to generate the report.

• The report is generated. 

Budget Details

• This report generates the budget details based on nominal codes. To generate the report, complete the following steps.
• On the Reports page, under the GENERAL LEDGER heading, click Budget Details.
• The Budget Details page appears. On the Budget Details page, enter the required criteria and click [Run].
• The report is generated.

Audit Trail Report

• This report shows the modifications on different documents performed by different users.
• Complete steps 1 to 4 as given in Trial Balance.
• On the Reports page, under the GENERAL LEDGER heading, click Audit Trail Report.
• The Audit Trail Report page appears. On the Audit Trail Report page, enter the required criteria and click [Run].
• The report is shown below.

Audit Trail Report shows the details of the time and user that run the Year End routine. To 
view, run the year end routine. On the Audit Trail Report page, from the TYPE list, select TB 
Journal and run the report. See the image below.