Modify the Transactions by Account Report
- In the Home window,
open the Report Centre. Select Financials
and then Transactions by Account. Click Modify this report.
- (Optional) Select
the Template
you want to use for the report.
- Select a fiscal
year: Next, Current, or Previous.
Available only if you have more than one year of data.
Note: To process transactions in the next fiscal year, ensure you have turned on the options Allow transactions in the future and Allow General Journal and payroll transactions for the next fiscal year or calendar year within the System settings for your company. (Sage 50 Premium Accounting)
- If you have set
up a foreign currency, select a Show accounts with
option:
- Balances
in Home Currency shows all foreign transactions in the home currency.
- Balances
in Home and Foreign Currencies shows all foreign transactions in
both the foreign currency and home currency.
- Balances
in the Currency of Each Account shows all transactions in their designated currency.
- Enter
Start and Finish
dates for the report.
- (Optional) Select
Include
inactive accounts.
- Select the account(s)
you want to include in the report. Click Select
All to report on all listed accounts.
- (Optional) Select
Corrections.
- (Optional) If you turned on departments,
click Departments. Click Select
Departments. Note: Consolidated companies do not recognize departments. (Sage 50 Premium Accounting)
- (Optional) If you are
working with a consolidated company, select Parent and subsidiary
companies. Click Select
Companies. (Sage 50 Premium Accounting)
- Select how you
want to sort the report: Transaction number
or Date.
If you are working with a consolidated company, the results
will be sorted by company and then by the selected Sort
option. (Sage 50 Premium Accounting)
- Select the type
of comment to include with General Journal entries: Transaction
or Line.
- (Optional) Customize
the:
- Click OK
to display the report.
- (Optional) Save
the report as a template in My Reports.
What do you want to do?
Change the presentation of this report in the report viewer
Print this report
View detailed information
about a specific part of this report
Search for text in this report
Open this report
in Microsoft Excel
Export this report
to another format
Change
your default printer settings for reports
Refresh this report