https://accountingaddons.com.au/wiki/excelreportlink/index.php?action=history&feed=atom&title=Transaction_Journal_ReportTransaction Journal Report - Revision history2026-10-26T04:03:19ZRevision history for this page on the wikiMediaWiki 1.43.11https://accountingaddons.com.au/wiki/excelreportlink/index.php?title=Transaction_Journal_Report&diff=59&oldid=prevNic: Created page with "== Overview == Transaction Journal Report This report displays a list of transactions ..."2014-04-02T22:00:37Z<p>Created page with "== Overview == <a href="/wiki/excelreportlink/index.php?title=File:ExcelReportLinkGLPivotSolution_TransactionJournalReport.png" title="File:ExcelReportLinkGLPivotSolution TransactionJournalReport.png">300px|thumb|right|Transaction Journal Report</a> This report displays a list of transactions ..."</p>
<p><b>New page</b></p><div>== Overview ==<br />
<br />
[[File:ExcelReportLinkGLPivotSolution_TransactionJournalReport.png|300px|thumb|right|Transaction Journal Report]]<br />
<br />
This report displays a list of transactions for a given financial year and month. It's aim is to mimick the layout of the Transaction Journal screen in MYOB but allow users to filter and find transactions.<br />
<br />
By default, the report is set to list all your transactions by including all companies, cost centres and jobs. It is restricted to display your Actual numbers for 2014.<br />
<br />
It displays the following columns across the page.<br />
* [[Transaction Date Field]]<br />
* [[Transaction Number Field]]<br />
* [[Transaction Type Field]]<br />
* [[Account Number Field]]<br />
* [[Account Name Field]]<br />
* [[Job Number Field]]<br />
* [[Transaction Memo Field]]<br />
* [[Debit Amount Field]]<br />
* [[Credit Amount Field]]<br />
<br />
It includes the following filters.<br />
* [[Version Name Field]]<br />
* [[Company Name Field]]<br />
* [[Cost Centre Name Field]]<br />
* [[Financial Year Field]]<br />
* [[Month Field]]<br />
<br />
=== Notes ===<br />
<br />
The [[Version Name Field]] is included to filter out budget figures from the report.<br />
<br />
== Customising the Report ==<br />
<br />
The report can be customised by editing each filter and selecting a value. As such, the report can produce figures for one or more companies, cost centres, jobs or financial years.<br />
<br />
== Related Topics ==<br />
<br />
* [[Transactions GL Pivot Reports]]</div>Nic