Old Reports -> General Ledger -> Movements

Parent Previous Next

Bug

The Movements report (Tools → Old Reports → General Ledger → Movements menu) and the Budget Performance report (Tools → Old Reports → General Ledger → Budget Performance menu) is exactly the same report (only the headings change).

1.The Period Lookup is not working. It displays all accounting periods on the printed report.

2.The Account Movements report displays the Budget figures for the year includes an extra month's budget figure. It also incorrectly includes the budget figures in Last Year's column instead of the actual transaction totals of last year's transactions. For example, it the total budget figure is entered as 120000 (10000 x12), the total is displayed as 130000 (13 periods) instead of 120000 (12 periods). The budget report on the T-Account Viewer is displayed correctly.

This report will reflect the movement of the value of transactions for a selected period for your general ledger accounts. Each General Ledger Account can reflect trends as to how your business is doing.

Print General Ledger Movements Reports

To Generate a General Ledger Account Movements Report:

1.Click on the Tools  → Old Reports → General Ledger → Movements menu.

The General Ledger Account Movement Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Sequence - You may select the selected accounts to be listed or displayed according to Account No., Account Description, Account Type, Account Group 1 or 2 (Reporting Group 1 or 2).

The description of Account Group 1 or 2 you have entered on the Reporting Group Name field on the Account Groups tab on the Setup → System parameters → Groups menu, may be reflected in this list.

b)From Account ... To - You may select all your accounts, a specific account, or a specified range of accounts, to be included in this report.

c)Include Zero Balances - If this field is selected, all accounts listed in your chart of accounts will be displayed and balances will only be displayed for those accounts with transactions. If this field is left blank, all selected accounts with transactions and balances will be displayed.

4.Click on the OK button to send the report to the medium selected in the Send Report to field.

View General Ledger Movements Reports

An example of a General Ledger Account Movement report generated is:

The details of the General Ledger Account Movement report will display the account code and name as headings, as well as any opening and closing balances for each selected account. The information is displayed in five (5) columns as follows:

1.Accounting Period - This is the accounting periods as set in the Setup → System parameters → Reporting Dates menu.

2.This Year - These figures would include the batches (Sales Journal, Purchase Journal, Receipts Journal, Payments Journal, Petty Cash Payments journal, etc. or any other batch type in which transactions were entered) which was posted to the ledger. If any documents (Invoices, Credit Notes, Purchase and Supplier Returns documents) were updated to the ledger and Point-of-Sale Invoices for which the Shift is closed, the actual transactions would be included.

3.Last Year - These figures would include the batches (Sales Journal, Purchase Journal, Receipts Journal, Payments Journal, Petty Cash Payments journal, etc. or any other batch type in which transactions were entered) which was posted to the ledger in the Last Year periods. If any documents (Invoices, Credit Notes, Purchase and Supplier Returns documents) were updated to the ledger and Point-of-Sale Invoices for which the Shift is closed, the actual transactions would be included for the accounting periods updated in the Last Year periods. If you have done a year end, the figures for the year which is closed, will be displayed as Last Year column.

4.Variance Amount - This is the amount of the difference between the transaction amount in This Year column and the Last Year amount in the Last Year column.

5.Variance Percentage - The difference between the transaction amount in This Year column and the Last Year amount in the Last Year column, is displayed as a percentage.

Income, Capital and Liability Accounts should reflect a credit figure and Expense and Asset accounts should reflect a debit figure.


Created with the Personal Edition of HelpNDoc: Produce electronic books easily