General Ledger & Reporting
Here are answers to a handful of the most Frequently-Asked Questions (FAQs) regarding General Ledger and Reporting when it comes to year end processing.
Can I print financial statements for the NEXT fiscal year PRIOR to performing year end processing?
YES. In the Fiscal Year field within the applicable report window, simply select the fiscal year to print.
DO NOT manually change the fiscal year in General Ledger Options in order to print financial statements for the next fiscal year.
After year-end processing, can I delete accounts that will no longer be used in the new fiscal year and still run comparison statements?
Information about prior fiscal years is stored by account number. These account numbers must be retained for as long as you require comparisons.
Instead of deleting, you can set the status of an account to Inactive which prevents future postings but still retains the account number for comparisons. On the Main Tab in Account Maintenance, select Inactive in the Status field and click Accept.
Can I open a closed fiscal year to make General Ledger postings/adjustments?
YES. If you retained detail history for a prior fiscal year by entering the ‘Years to Retain General Ledger History’ field in GL Options, you can reopen and post to a closed fiscal year.
To Post to a Closed Fiscal Year:
- Select General Ledger Setup menu > GL Options
- On the Main tab, in the Current Fiscal Year field, select the past fiscal year to re-open
- In the Current Period field, select the accounting period to post to and click Accept.
- In General Journal Entry or Transaction Journal Entry, enter the transaction to the reopened fiscal year and period and update the journal entry.
- Reprint year end reports when you’re finished.
- Go back to General Ledger Options Main tab and select the current year in the Current Fiscal Year field, and the current period in the Current Period field. Click Accept.
You’ve just re-opened the closed fiscal year, posted a journal entry, and reverted back (in step 6) to the current fiscal period and year.
Note: Closed fiscal years can only be reopened in the General Ledger module.
Can I process year end in General Ledger before I’m finished with the other modules?
NO. General Ledger should be the very last module you close. Refer to the Module Closing Order article earlier in this newsletter for details on the proper closing sequence.
TIP: How to Correct an Out of Balance General Ledger
There are a variety of reasons that your general ledger can get out of balance. In the video below, you’ll learn how to discover and correct the out-of-balance situation including instructions for making one-sided journal entries.
How to Setup Paperless Office to Save/Print Year-End Reports
Here are step by step instructions for setting up Paperless Office to save your period and year end reports in PDF format so they’re searchable and easy to retrieve later.
Setup Paperless Office
- Open Paperless Office, Setup, Paperless Office Options.
- In the ‘Enable Electronic Delivery and PDF Storage’ section, select all options.
- In the ‘Load Date on Initial Viewer Access’ section, select all options.
- In the ‘Keep Only the Last Copy’ section, select Period End Reports.
- Click Accept.
Setup Period End Report Maintenance
The following steps are applicable for all modules.
- Open Paperless Office and navigate to Setup > Period End Report Maintenance.
- Select applicable Company Code and module from look ups (Note: you can select any module or ALL modules).
- In the PDF Directory, enter the full path of an existing folder to use for storing the period-end report in PDF format, or click ‘Browse’ to choose a folder.
- Select whether to password-protect PDF documents which requires entry of a password to view the PDF after it’s created (Prompt = displays a message requiring you to define a password each time the PDF document is created, Yes = always protect the PDF document with the password entered in the Password field, and No = create the PDF document without password protection).
- If you chose the Yes option, type the password that will be required to view the PDF documents created.
- Confirm and re-type the password entered.
- Click Accept.
Paperless Office Report Maintenance
If you have the appropriate security access, you can also add public favorites. Public favorites are available to all users who can access them based on their security setup.
- Open Paperless Office and navigate to Setup > Period End Report Maintenance.
- Select applicable Company Code and module.
- In the Document field, select the report to define PDF settings for. This field displays all reports for the selected company and module. Select All Documents to define PDF settings for all reports in the selected company and module.
From here, the remaining steps are identical to steps 3 – 7 in the previous Period End Report Maintenance section above.
Refer to this support article for full details including setup instructions for payroll registers and reports.