The Pak Accounting General Ledger lists the detail transactions in date sequence for an account/Sub-Account combination. Transactions dated the same day are in reference number order. Date ranges, range of accounts and/or Sub-Accounts, and many other criteria can be selected to define the report parameters. The Ledger report can be exported as a .csv file through the CSV File button at the bottom of the screen. Additionally, the ledger report can be saved as an Excel workbook through the File button at the bottom of the screen or through the report viewer. If the file is to be imported into the General Ledger, #23-Import, the file type selected should be .xls or .xlsx.
Ledger Listing-Primary Options |
|
|---|---|
Print Detail Date Range: |
Transactions dated prior to the "from" date are summarized into a balance forward amount. Transactions dated after the "thru" date are ignored. |
Include only Accts with Sub-Table (leave blank for all) |
Define a Sub-Table in order for Pak Accounting to only list those accounts with that particular Sub-Table attached on the Ledger Listing. |
Account/Sub-Account |
You can limit what information is printed in the General Ledger Report by defining what account(s) and/or Sub-Account(s) in these ranges you would like printed. |
Only for selected Accounts |
Ability to select accounts to print on the Ledger Listing that are not in a consecutive range. Manually enter the accounts using a semi-colon as a separator or use the select accounts to pick which accounts to include. |
Only for Selected Sub-Accounts |
Ability to select specific Sub-Accounts to print on the ledger listing that are not in consecutive order. Manually enter the Sub-Accounts using a semi-colon as a separator or use the "Select Sub-Accounts" button to pick which Sub-Accounts to include. This helps to limit the scope of the report. If you wish to run the report for all Sub-Accounts, leave this field blank. |
Report Sequence |
Option to print ledger in account # or Sub-Account order. |
Blank Lines: |
Define where to print blank lines in the report. # of lines to print after each Account or after each Sub-total. |
Balance Forward Options: |
When printing a journal of the balance forward entries you have the following options: Normal - prints all the balance forwards within the date range; None - prints only the most current balance forward entry; and ITD also - prints normal with the ITD entries included. |
List Account Detail: |
Allows you to print All detail, no detail or use the defaults set up in Account Maintenance. |
Print Journal Sum |
Use the defaults set up in Account Maintenance, All by Month, All not by Month, or None at the end of each journal. |
Print Summary by Month? |
Add a summary at the end of each month. |
Print Column For: Quantity, User, Date/Time, |
Will print a columns for Quantity, User/Date/Time, and AFE/Stage if the different options are checked. |
Also Print Summary by: |
None- Will not print a summary. AFE- Will summarize by AFE. Batch ID- Will summarize by Batch ID. |
Sum detail by |
None-Will not summarize the detail. Acct+Inv#+Ref-Selecting this option will summarize the detail by Account and by invoice/ref. Acct+Vendor-Will summarize the detail by account and vendor. |
Report Title |
Enter a title to print at the top of the ledger report to describe what type of ledger you are printing. |
How to Print a Vendor Report by Lease
A vendor report by lease can be printed from the Ledger listing by choosing certain options on the Primary Options tab. First define the lease Sub-Table in the "Include only Accts with Sub-Table" field. Next enter the lease you would like the report printed for. Last choose the "By Acct+Vendor" option for the Summarize Detail by field.
The Secondary Options tab allows for the user to further refine what information appears on the Ledger report. Additionally this tab provides that ability to produce the report based on a Financial Reporting Group that is set up in Sub-Account maintenance.
NOTE: When filtering by amount, the system will filter the amounts between the values regardless of whether the range is input high to low or low to high.
Historical Unpaid/Unbilled Report The Ledger Listing can be used to run a historical Unpaid/Unbilled report.
For example, management needs to see what was unpaid/unbilled as of 12/31/2014.
Steps: 1. Enter the date range in the "Print detail date from/thru" fields. Since we want to see anything that was unpaid/unbilled up to 12/31/2014, we will leave the "from" field blank and the "thru" date will be set at 12/31/2014. 2. Enter the Billing account range in the "Account from/thru" fields. In this example the billing account range (to include the Billing Offset account is 9000-9599. 3. (Optional) If you wish to see the Account Detail, click "All" on the "List Account Detail" options. 4. On the "Secondary Options" tab, a date must be entered in the "A/P Paid Date From/Thru fields and the "Include Unpaid" box must be checked.Notice that even though we want to see what was unpaid/unbilled up to 12/31/2014, we have entered the A/P Paid Date starting with 1/1/2015 thru 12/31/2015. 5. You can now generate the Ledger Listing.
|
This tab provides the ability to produce the ledger for a specified date range by vendor and/or a PO# range. |
The Ledger/User ID & Date Options tab provides the ability to print the ledger: •With last change information (i.e. listing includes the User ID of who made the last change to each transaction) •By transactions extracted in a particular Revenue/Billing cycle. A further option is to restrict the account type to only revenue accounts, only billing accounts, or not to restrict the account type at all •Based on Effective or Production Date |
Ability to print the General Ledger using wildcard selections. Use the question mark or * to indicate "wildcards". For example, 21?? Will print all accounts starting with the numbers 21 -- (2100 thru 2199). Sub-accounts are alphanumeric. Selecting ABC??? will print all Sub-Account that begin with the characters ABC, and will ignore all others. If you want to find a particular word in the description field enter *word* and any descriptions that contain that word will print on the ledger listing. |
This tab provides the ability to:
Set Page Orientation, Font Size, and Font.
Print Format Ability to run: •Normal •As a running balance of the amount and quantity •As Separate DB/CR
Print Associated Document Select Associated Documents to print the documents scanned in with the transactions (Note: must have scanning feature turned on). *When Printing Associated Documents, there is also the ability to Print Approver Information which is used in conjunction with scanning and approval routing paths. There is also the ability to Limit any individual doc to this # of pages (0=no limit).
Output to Excel: •CSV that is the same format as the original DOS WolfePak G/L system. •G/L Import option allows you to export entries to Excel that can be imported back in via the Import Utility in the General Ledger module. This is the default for the screen. •For all of the detail with the entries such as fiscal year, you will need to select the "All Fields" option. •AP Paid Date option is checked (chosen), then an A/P Paid column will be added to the Excel. With this option checked, all of the entries associated with an Invoice (both the recording of the A/P itself and the various expense entry(s), replicate the Invoice's paid date on each entry. If the entry is not an A/P Entry, then the A/P Paid date will be blank.
Choose the type of export you want (DOS Format, GL Import, or All Fields) and whether you would like to include the AP Paid Date before clicking the Excel button at the bottom of the screen. The Export Docs for Excel button allows export of Docs that are associated with posted General Ledger transactions based on the selected transactions generated in the Ledger Excel option and they will be in the same folder as the list in PDF format. Select whether you would like one file per line or one file per image. |