General Ledger
Is There a Way to Pull All Manual GL Entries Out of Elliott?
Elliott has no predefined report to do this. We suggest you use the Export Processor as follows: On the first tab labeled Category, choose "GL Transaction file"; On the 2nd tab labeled Selection, choose GL_TRX_SOURCE between (BT) GJ0000 to GJ9999, ...
How to Print a Wider Financial Statement
One of our customers recently asked how to print a financial statement with wider margins. They were attempting to print a P&L Statement with comparative year columns, but the comparative year was truncated. They tried using a smaller font, but it ...
General Journal Transaction Out Of Balance After Interface with AR
Customer question: While I was interfacing with AR, someone posted a cash receipt payment. Now my interface is out of balance. Can I just delete the transactions and then re-interface? Answer: If you interface once a month, yes, you may delete the ...
How to Archive GL Data Before Year-End Closing Procedure
Q: Our year-end closing procedure will purge all detail transactions, but I don't want to lose my previous-year GL transactions because they contain important data that I would like to go back to for reporting and auditing in the future. So I would ...
GL Year-End Closing Checklist
Q. GL year-end closing is a major event for our accounting department every year, but it's easy to forget the steps involved since we only do it once a year. Do you have a checklist for year-end closing that we can follow? A. Yes. The GL year-end ...
Can Journal Ledger Be Imported to General Ledger?
Q - Can the General Journal ledger be imported from a spreadsheet into the General Ledger as opposed to manually entering it? A - Yes. You can go to General Ledger -> Processing -> Interface from Other Package -> CSV Import. See sample screen below. ...
Do I Need to Kick My Users Out When Interfacing with Other Packages in GL?
Q - When interfacing the sub-ledgers (i.e., AR, AP, IM) to the General Ledger, must all other users exit Elliott? Or if we are interfacing only AP, can users just stay out of AP, for instance? A - The key is that no one should perform any "POSTING" ...
General Journal Transaction In Balance But Not Able to Post
Q - My General Journal Transaction screen, Session ID, shows that the total debit and credit amounts are in balance. See sample screen below. But when I print the General Journal Edit List, it shows that they are out of balance. In addition, I can't ...
Net Income from Profit & Loss Statement Does Not Match Balance Sheet
Q. Normally the Net Income amount on my Profit & Loss Statement always matches the Balance Sheet of my monthly financial statement. Unfortunately, they don't match this month. How can I find out why this happened and resolve the problem? A. There are ...
Feature - G/L Interface from Other Package Customer/Vendor/Employee Number/Name Default
Release Date - 2/12/16 When interfacing to G/L from other packages and the user chooses to interface A/R, A/P or Payroll distributions, the application will prompt the user asking if they want to interface using the customer/vendor/employee number or ...
Error During GL Interface from Other Package and Journal Transaction Is Lost
Q - In General Ledger, during the interface from other package process, I got a Btrieve Error 3112 on AP Distribution File (APDISFIL). The interface stopped and my Elliott session was terminated. I went to General Ledger -> Processing -> General ...
COMPRESS General Ledger Processing Compress General Ledger TRX File
Compress General Ledger Trx File Application Overview The Compress General Ledger Transaction File application will consolidate General Ledger transactions according to the account's compression code in the G/L Account file for all transactions dated ...
GLACTMNU General Ledger G/L Account File
G/L Account File Application Overview The G/L Account File is used to set up and maintain, as well as print out a list of all or a subset of all accounts on file. The Account number entered for each record can be divided into three related components ...
GLBUDMNT General Ledger Budget File Maintenance
Budget File Maintenance Application Overview For purposes of the Budget File application, a budget is the targeted or anticipated net change to a given account during a given period. For example, sales of a specific product line may be targeted at ...
GLCMPMNT General Ledger Comparative File Maintenance
Comparative File Maintenance Application Overview The purpose of the Comparative File application is to maintain a prior‑year comparative amount that will be understood as the previous year's year‑to‑date activity for a given account, as of the end ...
GLCONSOL General Ledger Company Consolidation
Company Consolidation Application Overview The Company Consolidation application is used only by businesses and organizations, which include a main, corporate, and one or more subsidiary companies whose General Ledger transactions need to be merged ...
GLCTLMNT General Ledger G/L Setup
Util-Setup G/L Setup Application Overview G/L Setup is not an application that you will be running very often. In this application, you will answer some questions that tailor the General Ledger package to the way you do accounting in your company. ...
GLDSTMNT General Ledger Distribution Code File Maintenance
Distribution Code File Maintenance Application Overview The Distribution Code File application allows the user to maintain his Distribution codes. These codes must be entered as one of the setup steps after entering the G/L Account File. The basic ...
GLENTMNT General Ledger Financial Entity File Maintenance
Financial Entity File Maintenance Application Overview The Financial Entity File application enables you to define financial entities within the main G/L Account File. These entities may then be reported upon individually by entering the entity's ...
GLJNLLST General Ledger Journal History Report
Journal History Report Application Overview The Journal History Report produces a listing of all journal totals. To maintain journal history totals, the field in G/L Setup must be set to "Y". Each posting procedure that is performed for any package ...
GLPRDMNT General Ledger Accounting Period File Maintenance
Maintenance Accounting Period File Maintenance Application Overview The Accounting Period File application should be the second application used (after G/L Setup) if the user is installing the General Ledger package for the first time. It allows the ...
GLPRDSCN General Ledger Period Account Balance Report
Period Account Balance Report Application Overview The Period Account Balance Report compiles G/L account activity over a given range of financial periods. It prints a report that provides the starting, ending, and period balances for each account ...
GLRATSCN General Ledger Financial Ratio Report
Financial Ratio Report Application Overview The Financial Ratio Report provides a useful resource in both charting the performance of your organization and comparing it's various financial components over a given period of time. It displays four ...
GLRECALC General Ledger Recalculate Account Balances
Recalculate Account Balances Application Overview The Recalculate Account Balances application recalculates the balances of G/L accounts. It recreates the Account Balance File from information in the General Ledger Transaction Processing File. This ...
GLRECENT General Ledger Recurring Journal Trx Processing
Recurring Journal Trx Processing Application Overview The Recurring Journal Transaction Processing application allows standard recurring journal transactions to be entered. They may also be changed before being posted to the General Ledger through ...
GLSRCMNT General Ledger Source File Maintenance
Source File Maintenance Application Overview The Source File application links the "source" with a corresponding General Ledger transaction. All such transactions encompassed in the main General Ledger Transaction file originate in a specific Journal ...
GLMENU General Ledger Package Overview
Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...
GLTRIALB General Ledger Trial Balance Report
Trial Balance Report Application Overview The Trial Balance Report application prints a Trial Balance report in account number or profit center order. These two options provide a detail or summary for a range of accounts that fall within a specified ...
GLWRKSHT General Ledger Print General Ledger Worksheet
Print General Ledger Worksheet Application Overview The Print General Ledger Worksheet application shows the Trial Balance for specified accounts and provides space beside the account information for the entry of adjustments. A General Ledger ...
GNJINLENT General Ledger General Journal Trx Processing
Processing General Journal Trx Processing Application Overview The General Journal Transaction Processing application allows for Journal Transaction entries and changes before posting to the General Ledger. Transactions may be keyed directly into the ...
INTERFAC General Ledger Interface From Other Packages
Interface From Other Packages Application Overview Interface From Other Packages allows the distribution files of Accounts Receivable, Accounts Payable, Payroll, Job Costing, Inventory Management, and Assets and Depreciation to be transferred into ...
SRCEXREF General Ledger Source Cross Reference Report
Source Cross Reference Report Application Overview The Source Cross Reference Report details all transactions for a specified period by source code. Under each source, the G/L account number, description, transaction date, debit and/or credit amount, ...
TEXTMNT General Ledger Statement Text File Maintenance
Statement Text File Maintenance Statement Text FileApplication Overview The Statement Text File application allows the entry and maintenance of special instructions and explanatory data that are to appear on the financial statements. It can be used ...
YEAREND General Ledger Year-End Procedure
Year-End Procedure Application Overview The Year-End Procedure application is performed at the end of your accounting year. This program rolls the Accounting Period dates forward to those of the current year. Do not do this manually. The program ...
My Net Income (BSNI) at Balance Sheet Does Not Equal My Net Income on the P&L Statement
Q: My BSNI (Net Income) on the Balance Sheet does not equal my Net Income on the P&L Statement. How do I investigate? A: There are serval scenarios and different ways of handling this situation. 1. If the BSNI amount does not match the P&L Net ...
My General Ledger Interface with Other Package Is Out of Balance
Q - When I go to GL -> Processing -> Interface from Other Package, I choose to interface with the IM module. After the interface, my GL Journal transaction shows it is out of balance. How can this happen? What should I do? A - Generally speaking, the ...
Budget File Maintenance Questions & Answers
Release Date: 6/20/2017 Q - My accounting year is May 1 thru April 30. We haven't yet closed the year just ended on 4/30/17, so there are dollar amounts in most accounts. A - You may run Export Processor to retrieve year 2017 account balances as a ...
LAYMNU General Ledger Statement Layout File Maintenance 1
Statement Layout File Maintenance Application Overview The Statement Layout File application enables you to create and modify Financial Statement Layouts. The features include: Add provides for the entry of financial statement layouts. Change ...
LAYMNU General Ledger Statement Layout File Maintenance 2
Account Numbers and PATS The most important item on a layout is the account number. When coding a financial statement, first consider all the accounts whose amounts must be included in the statement and the order in which they should appear. On a ...
LAYMNU General Ledger Statement Layout File Maintenance 3
Ratios Ratios can only be printed on the Profit and Loss Statement and the Profit and Loss Format Supporting Schedule. In order to be able to select ratios to print on a statement, you must define the basis upon which the ratios will be calculated ...
Next page