A list of accounts is displayed in a grid, which can be filtered or searched within.
Export – Used to create an Excel file from the contents of the grid, either the entire list of accounts or only those displayed through a Filter or a Search.
Add – Adds a new GL account.
Edit – Edits the highlighted GL account.
Delete – Deletes the highlighted GL account. This account cannot be deleted if it has anything posted to it.
Copy – Create a new account based on the information from the highlighted account.
Revalue – Recalculate the base amount for the accounts set up with another currency, from the current exchange rate and the foreign currency balance. The difference will be posted to the Gain/Loss setup for that specific currency. See the manual for Multi-Currency for more details.
Create Transaction – Start a new journal entry transaction.
Print – You can select one or more accounts to print particular reports for the selection, or print the reports for all records. Other Financial Statements can be printed, regardless of the account selection.
Balance Sheet – Prints accounts and their ending balances as of the end of the current fiscal period, along with totals by account type. Account Group totals may also be configured for reports.
Comparative Financial Statement – Prints columns for the year to date ending balance as of the current fiscal period, for both the selected fiscal year and the year previous to that. Variance amounts and percentages by account are calculated.
Financial Statement by 12 Periods – Prints columns for all 12 periods of the current fiscal year, with end of period amounts populating columns up to the current period. Periods after current will print zero amounts instead of any actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 12 periods.
Financial Statement by 13 Periods – Prints columns for all 13 periods of the current fiscal year, with end of period amounts populating columns up to the current period. Periods after current will print zero amounts instead of any actual amounts. Accounts with subgroups defined are printed together with a subgroup total. Gross Profit and Operating Income are calculated for each period. Use this report for companies that have a fiscal calendar with 13 periods.
Financial Summary – Prints at the top, the account balance subtotals by account type, as of the current fiscal period and year, in separate Assets and Liabilities and Equity section as a summarized balance sheet. Prints at the bottom, Revenue and Expense account subtotals by account type, for Period to Date, Quarter to Date and Year to Date columns as of the current fiscal period and year, as a summarized income statement.
GL Chart of Accounts – Prints a list of selected accounts with their respective names, groups, sub-groups and designations.
GL Account Foreign Balance – Prints a list of accounts configured with a non-base currency, and at least one of their respective opening, net change and closing balances for the current fiscal period and year are non-zero.
GL Open Balance Check – Prints a list of all accounts and their respective names, currencies and opening balances. This report is typically used only when first creating a new Spire company database, to verify that starting balances are correct.
Income Statement – Prints a list of accounts grouped by revenue and expenses, with Period to Date, Quarter to Date and Year to Date columns as of the current fiscal period and year, for actual amounts and the respective percentages to total.
Trial Balance – Prints a list of accounts where at least one of their respective opening, net change and closing balances for the current fiscal period and year are non-zero.
Edit and Add Accounts
Save – Save changes to the account and leave the screen open.
Save Close – Save changes to the account and close the screen.
Delete – Deletes a GL account. This is only allowed if there are no transactions posted to the account.
Print – Prints all reports that have a Crystal Report template of “GL Account”
Reconcile – Perform an account reconciliation for this GL account. Most commonly it is for bank accounts and credit card accounts but any GL account can be reconciled. See Account Reconciliation for more details.
Division No – If Divisions are turned on in Company Settings/General Ledger, then each account will have a division, for the purpose of maintaining separate charts of accounts. Each account will also have a consolidated division of ‘000’ maintained by Spire when transactions are posted, for the purpose of consolidated company reporting.
Account No – The General Ledger Account number, which can have up to 4 separate segment codes and 24 characters. Two segments may be reserved for Locations and Profit Centers.
Name – A descriptive name for the GL account, which will appear on other transaction screens when this account is selected.
Currency – The currency assigned to this account. It can be set only when the account is first created, otherwise this field is not editable.
Inactive – When enabled, this GL account cannot be posted to.
Details
Group – The pre-defined account group code that the account belongs to, used for reporting organization and assigning the account Type. Groups can be modified in Company Settings/General Ledger
Subgroup – The subgroup that the account belongs to, used for reporting organization and consolidated vs detailed results. The selected subgroup should below within the defined account group, as configured in Company Settings/General Ledger.
Normal Balance – Select Debit if the account balance will typically have a debit value, and Credit if the account balance typically will have a credit value.
Type – The account type from the selected group is displayed here and cannot be changed.
GIFI Account – An acronym for ‘General Index of Financial Information’, enter the associated code as set out by CRA (Canada Revenue Agency) for specialized financial reporting. See this link for more information.
Check sequence – The next check number that will be assigned by default when a payment using this account as the Bank Account is created. If the account does not have the Bank Account setting enabled, this field will not be editable.
Last statement balance – The amount of the closing balance for the most recently posted account reconciliation. This field can only be edited if the User Setting for General Ledger to Modify Last Statement Balance is enabled. You would only edit this value if you need to make a correction to accommodate the next account reconciliation Opening Balance.
Sales Account – Define that this account is a sales account, to use for Filters or custom reporting.
Bank Account – Define that this account is a bank account, which enables the Check Sequence field and allows it to be selected as the Bank Account on payment transactions or the Vendor Payment field.
Revalue – Enable this option for accounts using a currency different than the base currency, to allow this account base currency balance to be recalculated from the current exchange rate by the revaluation process.
EFT Settings
The EFT Settings tab is where you enter your banking information to be used with payroll direct deposit and accounts payable and accounts receivable EFT. Information is only accessible when the account has the Bank Account setting enabled, as this functionality is only available with bank accounts. Supported configurations are CPA Standard 005(1464), TD 80 Byte, NACH ACH (94 Byte), and CIBC (1464 Byte).
Create a new EFT Format from the Plus button at the bottom left of this screen. You may create one EFT Configuration for each supported format, for each GL account. For the fields available in the specific EFT Configuration, check the documentation provided from your bank to ensure that field values conform to specifications, such as using correct character types, required values and not exceeding field length maximums.
Use the X button at the bottom left of this screen to delete the highlighted EFT Configuration.
Account Transactions
This tab displays all posted transactions that include the edited account.
Refresh – Re-read the grid results to display all posted transactions to this account, including any Filter criteria if used.
Filters – Use search criteria to display only particular transactions of interest.
Search Box – List account transactions that contain the entered word(s) in searchable text fields.
Export – Export the filtered and sorted list to Excel or .csv.
Print – Print any report with the Crystal Report Template of GL Transaction List.
Transaction – Choose to either View the complete journal entry, or View Source for the source transaction that produced this journal entry, from particular module posting. Source transactions from Sales Orders, Purchase Orders and Payroll can be opened, but not from Accounts Receivable, Accounts Payable, Inventory or General Ledger.
Grid Columns
Transaction No – The GL transaction number that was generated during posting, from the next transaction number in Company Settings/Sequence Numbers.
Source – The module / transaction type where this transactions was posted.
Transaction Date – The date that the transaction was posted to.
Type – The type of transaction that was posted.
Document – The document number passed from the subledger posting, such as the invoice or check number.
Entity – The customer, vendor or employee code of the posted transaction. Some transaction type will leave this field blank.
Debit – The amount of the debit transaction. If it was a credit amount, this column will display zero.
Credit – The amount of the credit transaction. If it was a debit amount, this column will display zero.
Posted Date – The computer system date when the transaction was posted.
Currency – The currency code for the transaction, which will be blank for base currency transactions.
Foreign Debit – The source currency amount of the debit transaction. If it was a credit amount or a base currency transaction, this column will display zero.
Foreign Credit – The source currency amount of the credit transaction. If it was a debit amount or a base currency transaction, this column will display zero.
Memo – A text comment that may have been added to the account line entry.
Reconciled – The checkbox will display as selected if the entry has been reconciled.
Reconciled Date – The date that the entry was reconciled. If blank then it has not been reconciled.
User ID – The initials of the user that posted the transaction.
Account Balances
Period end dates and respective period net changes and ending balances are displayed for the 3 years open for posting. Columns with a triangle in the title are for the period net changes for that fiscal year, and columns with just the fiscal year are for ending balances. The period that contains the Spire login date will be highlighted in bold font as a reminder. When a year end procedure is done, the balances from the oldest of these years get moved to history, the other years are shifted to the left, and a new year is created at the right side.
View – For the highlighted fiscal period/year, the posted transactions are displayed in a new window.
Foreign Currency – Toggle to see the base and foreign currency values, available only for accounts defined with a different currency than base.
Account History
Fiscal years older than the three years available for posting will be displayed for inquiry on the History tab. Historical years are only available for viewing and reporting, and can no longer be posted to. Double-click on any year to see the amounts broken out in separate fiscal periods.
Fiscal Year End – Year end date of the historical year.
Ending Balance – The closing balance of this account as of the fiscal year end date.
Net Change – The net posted amount for the fiscal year, with the amount displaying negative if the balance decreased.
Budget – The total year budget amount for this fiscal year.
Variance – The difference between the Net Change and Budget amount for this fiscal year.
Historical Balances
Period End Date – The end date for each period of the closed year.
Net Change – The net posted amount for the fiscal period, with the amount displaying negative if the balance decreased.
Balance – The closing balance of this account as of the fiscal period.
Budget – The fiscal period budget amount.
Cumulative Budget – A running total of the fiscal year budget amounts, with the total year budget displaying in the last fiscal period. This is best used to compare with the account Balance as of any fiscal period for income statement accounts.
Communications
Any number of notes can be added for this GL account, following the usual rules for adding communications, including attachments or assigning to users.
User Defined Fields
User defined fields can be added to track and/or print information not already available on other screens.
Reports
When editing an account, the report button at the top of the window gives you access to this list of reports.
GL Account Period Balances – Prints a list of the three open fiscal years and each period within, including their respective period net changes and ending balances. This replicates the data presented on the Balances tab.
GL Account Period Balances Foreign – Prints a list of the three open fiscal years and each period within, including their respective period net changes and ending balances in the currency of the account. This replicates the data presented on the Balances tab when the Foreign Currency button is toggled on.