A common request this time of year is to provide a copy of the trial balance in an electronic format for auditors. Microsoft FRx Report Writeris the best tool for fulfilling this request. It can easily be done by importing the chart of accounts into a row format, creating a column layout that includes the General Ledger account codes, description and actual year-to-date amounts. If you have multiple segments in your account format ask your auditors if they want the accounts in summary or in full detail. If you use the automatic import method to help build your rows, be sure to remove all of the entries that tag the account as a credit account. The auditors may also have other requests including the year’s beginning balance and net change in addition to the ending account balances. When you generate the report be sure to include accounts with zero balance and choose Excel as the destination option and the file will be ready for the auditors.
Another common question comes up when you need to add rows at the end of your FRx report. You insert rows just like you do in Excel: highlight a row, right click and select to insert row, this adds a row above the one you highlighted. If you need more rows at the very bottom you simply click on your computers down arrow key and new rows will be opened. This same trick works for columns: simply click on the right arrow button on your keyboard.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.