General Ledger -Details Reports

General Ledger -Details Reports



Print GL Details-Account

User can choose the account number for which the details of transaction print to be taken or can choose multiple accounts as shown below for generation.


Multiple Account Reports -Sample

Print GL Details -Inventory

The report can be generated for a range of dates to know exactly the inventory tag

used against a customer for an invoice, it can be material or a material used for processing.

Print GL Summary -Account Range

The report is configured to provide the summary of the selected accounts with  date range fiscal Year to date,

 

Last Month, Quarter, Month to date etc.


Trial Balance

A trial balance is a report that lists the balances of all general ledger accounts.

of a company at a certain point in time.

The accounts reflected on a trial balance are related to all major accounting items, including assets, liabilities, equity, revenues, expensesgains, and losses.

It is primarily used to identify the balance of debits and credits entries from the transactions recorded in the general ledger at a certain point in time.
It's mainly used to identify error; the trial balance is prepared to make the necessary adjusting entries to the general ledger.

It is prepared again after the adjusting entries are posted to ensure that the total debits and credits are still balanced.

It is not an official financial statement. It is usually used internally and is not distributed to people outside the company.

Print Trial Balance Detail

The report will be generated in detail (Transaction wise) for each account and will run into pages to identify any error in accounting wrongly.

 


Print Trial Balance Summary

The report provides only the Summary (Total) against each of the ledger accounts.

with opening balance, closing balance and account posting during the selected period /range of dates.

 



Income Statement

The Income Statement is one of the company’s core financial statements providing the profit and loss over a period of time. 

The profit or loss is determined by considering all revenues and deducting all expenses from both operating and non-operating activities.

The income statement is one of three statements used in both corporate finance (including financial modelling) and accounting.

The statement displays the company’s revenue, costs, gross profit, selling and administrative expenses,

other expenses and income, taxes paid and net profit in a coherent and logical manner.


Balance Sheet

A balance sheet is a financial statement that reports a company's assets, liabilities, and shareholder equity.

The balance sheet is one of the three core financial statements that are used to evaluate a business.

It provides a snapshot of a company's financial Situation for the Creditors, financial institutions and Share Holders

of the Company (what it owns and owes) as of the date of publication.

The balance sheet is prepared in 2 formats one is detailed , which provides break up of individual Accounts

and the other format is  summary of expenses where a Shell (Header) Account is used to summarize the expenses under a broad heading .

 



The below balance sheet has summarized the individual Accounts under 1100 (Inventory Asset) and 2050 (Accrued Expenses)

of the child account as maintained in Chart of Accounts.

 

Checking Debits & Credits

The System has been designed to post the transaction in the appropriate Account Heads,

also, the System is configured to populate error messages when the wrong account heads are chosen.

Refer Screen shot below, there are chances of selecting wrong account head when GL(JE) entry is created .

The report helps to check the account with debits and credits for a period to identify the errors.

AP Journal Report

The report can be generated in detail, summary or only by total of all the

transactions that alter Account Payable directly or indirectly for a period or Range by account number or by Vendor 


 

AR Journal Report

The report is similar to the AP Journal report  can be generated in detail ,summary or only by total of all the

transactions that alter Account receivable directly or indirectly for a period or Range by account number or by customer.

 

AR Roll Forward Report

AR roll forward is a ledger account’s closing balance that becomes a opening balance in the subsequent period.

it's part of so called “roll forward reports,” which include a breakdown of the

current period opening balance and all debit and credit activity — the sum of which is the roll forward value (a.k.a closing balance).

Deposit Reports

Deposit Breakdown Reports

The Deposit report includes information about each deposit, including a

summarized breakdown of payments methods, discount, bank charges 

and bank information such as the account number and routing number.

if any corrections exist for a deposit, the same can be viewed the correction date, method, type and amount


Deposit Breakdown by Check

The report lists the details of individual check numbers, date of check, amount etc.,

that forms part of a deposit number.

Graphical user interface, applicationDescription automatically generated

Deposit Summary

The report is a summary for the deposit number of the total amount and date

Graphical user interface, applicationDescription automatically generated

Cash Disbursements

Cash Disbursements Detail

A cash disbursement transaction / Bank disbursement is a record kept by a company's internal accountants that itemizes all.

financial expenditures a business makes before those payments are posted to the general ledger.

On a monthly basis, these journals are reconciled with general ledger accounts,

which are then used to create financial statements for regular accounting periods?

Graphical user interface, applicationDescription automatically generated

 

Cash Disbursements Summary

Graphical user interface, applicationDescription automatically generated

 

Cash Disbursements By GL Acct Detail

Graphical user interface, applicationDescription automatically generated

Cash Disbursements By  GL Acct Summary

Graphical user interface, applicationDescription automatically generated

Processor Reports

Revenue by Account No

Revenues are the assets earned by a company’s operations and business activities.

Revenues include the cash or receivables received by a company for the sale of its goods or services.

The report can be generated individually for each revenue account for a given period.

Revenue By Customer by Account No

The report is generated for the period selected the invoices raised on

the customer for the material or any processing done.

TableDescription automatically generated with medium confidence

Daily Status Report - Customer Material

The report lists the material received raw and finished goods on PO's raised (Reserved Customer),

processed against each shift, machine id as on a given date and with specific data on the date before input date. 

 

Daily Status Report - Owner Material

The report lists the material received raw and finished goods  from

customer for processing raw material and finished goods,

processed against each shift, machine id as on a given date and

with specific data on the date before input date. 

Graphical user interface, text, applicationDescription automatically generated

Production Transaction Report

The report provides opening balance of inventory details of raw material, finished goods received for the period , work orders

processed during the period both on raw material and finished goods, scrap generated, material invoiced and shipped for the period.

TextDescription automatically generated with low confidence

Shift Production Details

The report is generated for a period with the shift number and machine id to know

how mow many work orders has been processed, weight, downtime of the machine and productive hours.

Graphical user interface, applicationDescription automatically generated

TableDescription automatically generated


Shipment & Invoice Report

The report can be generated for an individual customer or if left blank.

all customers invoices raised during the period will be listed, invoices raised for the period.

with details of raw material, finished goods shipped and invoiced (in TONS) for the date range.

Graphical user interface, applicationDescription automatically generated

TableDescription automatically generated

Outstanding Checks

The report lists out all check prepared and not issued to the Vendors and

check is yet to be banked by the vendors to the bank. 

Graphical user interface, applicationDescription automatically generated

DiagramDescription automatically generated with medium confidence

Check Listing Report

The report lists all check prepared for the period,

online payment transactions and bank charges raised by bank and accounted.

Graphical user interface, applicationDescription automatically generated

TableDescription automatically generated

Print Initial Balances

The report lists all opening balances of the company in terms of liabilities and assets.

TimelineDescription automatically generated with medium confidence

Borrowing Base Report

The report is generated to calculate the loan availing capacity based on the account receivables and inventory.

Graphical user interface, text, applicationDescription automatically generated

Business Status


The report is generated as of the last period closed or as on date, with data of aged inventor, account receivable with aging , 

invoices raised, steel, freight and sales margin. 

Graphical user interface, text, applicationDescription automatically generated


A picture containing timelineDescription automatically generated


TimelineDescription automatically generated 

Inventory Write Downs

An inventory write-down is process used to reflect the correct value of inventory it may be due to rust, wear and tear

or its market value drops below the book value. The write down can be.

due to material processing which leads to non-useability, there by the cost of the material has to be written down.

The write-down impacts the balance and income statement of a company and affects the business's net income and retained earnings.


Graphical user interface, applicationDescription automatically generated


DiagramDescription automatically generated

13 Week Cash Flow

A cash flow statement is a financial statement that provides aggregate data.

regarding all cash inflows a company receives from its ongoing operations and external investment.

It also includes all cash outflows that pay for business activities and investments during a given period.

The report provides details of actual cash flow for the previous period of 13 weeks as on a given date.

Graphical user interface, applicationDescription automatically generated

TableDescription automatically generated


13 Week Cash Flow Projection

The report for the forthcoming 13 week based on the expenses and revenues.

earned on the actuals of the past 13 weeks period is taken as basis and projected.

Graphical user interface, applicationDescription automatically generated

TableDescription automatically generated


Future Cash Disbursement Flow by Account

The report is based on the expense’s actuals incurred for

the last 13 weeks being projected as expenses for individual account.



    • Related Articles

    • General Ledger

      General Ledger A business maintains numbered accounts to keep track of its financial transactions to ensure propriety of the accounting process. General ledger helps in extracting a Trial Balance, preparing Profit & Loss Account , Finalizing Balance ...
    • Other Topics -General Ledger

      Initialize GL Year The process is to create accounting periods for transaction to be posted. Maintain Periods The accounting periods are to be maintained to ensure transactions are not posted to previous closed period without proper approval and ...
    • Receivables-Reports

      Open Invoices for a Customer The above browse list is populated to select customer, after selection the below additional comments pops up to enter comments which is printed in the report generated for all the invoices open for the customer, the ...
    • GL Reconcile Details

      Detail Reports Monthly Detailed Reports Receivables Summary Report An accounts receivable aging report refers to a summary of all receivables. due from customers at any given point in time. The report breaks down receivables due from all customers ...
    • Reports

      Accounting reports are compilations of financial information that are derived from the accounting records of a business. Reports can be brief, custom-made reports that are intended for specific purposes, such as a detailed analysis of sales by ...