Pathway:Accounting > GL Transaction Processing
| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
GL Transaction Processing consists of four screens that allow you to review all transactions posted in Navusoft by GL Account, and create new GL batches to post to your general ledger. Transactions displayed on the screen are organized by A.R. period, and Type.
Prerequisites
Batches are not able to be included in GL processing if there are any errors linked to them. Follow the steps below to resolve any setup errors the system has identified.
1. Review Setup Errors
Setup for GL accounts is reviewed when the GL Transaction Processing screen is opened. Setup Errors will show missing accounts or bad setup that must be reviewed to make necessary changes. To review:
Select the ‘Setup Errors’ link to open the GL Setup Errors popup window.
Review the Setup Warning column for the reason a warning
...
Part of 67 Release
The GL (General Ledger) Batch Processing tool is used to store and summarize all of a company’s transactions. This tool walks through the steps of moving pending transactions to posted using a batch process.
Create a GL Batch
was triggered. This is only informational and is not a link to the setup tools.
Leave the GL Transaction Processing tool and navigate to the location(s) setup is needed.
After setup has been fixed, return back to GL Transaction Processing and Load the Pending screen again. This will trigger the system to review Setup for GL accounts once again and clear the errors that were fixed.
...
2. Review Transaction Errors and Fix Errors
This step assumes Setup Errors have been reviewed and fixed and the Pending screen refreshed.
In the event an error count displays in a batch’s Errors column AFTER setup was fixed, select the error to view the affected GL Account. If setup is correct and expected GL changes are correct, select Fix Errors.
...
Create a GL Batch
After a batch has been created, it is available to view and Post from the In Progress tab.
...
From the Pending tab:
Select the AR Period. Only transactions from the selected period will display.
Select Type to filter and display a specific type of transaction on the screen.
Select all the transactions you would like to include in the batch.
To select all transactions, check the empty box in the upper left-hand corner of the header. Otherwise, check the box to the left of each transaction that the batch should include.
Select Create GL Batch and a Confirmation window will display.
Enter a note to display along with the batch.
Select Create Batch.
...
In Progress Batches
Use the In Progress tab to review GL batches before they are posted. Double click within the row of the batch to drill down and view the GL Accounts it includes. From here, the option to export to Excel is available and located to the left of the Search boxThis screen (and the Posted screen) features drill down functionality to view information by GL account and then by transaction.
| Info |
|---|
If needed, reverse a batch from In Progress back to Pending by right clicking within the row of the batch and selecting Reverse Batch. |
...
Post a GL Batch
To post a GL batch after it has been reviewed, the following steps applyare used.
...
From the In Progress
...
tabs:
Hover over Right click on the batch you wish to post and right-click. A pop-up window will displaythat is ready to be posted.
Select the Post Batch option from the pop-up menu and a Confirmation window displays. list of options that display.
When the Confirmation window Select Yes to confirm. The batch is now posted.
Export a GL Batch
...
To Export:
Select the In Progress tab if the batch has not been posted, or the Posted tab if it has.
Hover over the batch being exported and right-click. A pop-up window displays. Right click on the batch you would like to export.
Select Export Batch from the list of options that display and the Batch will be exported to Excel.
Summary
The Summary tab summarizes the transactions for each general ledger account by period.
...
A view summarizing all GL account activity for a selected period and batch status is available in the summary screen.
...
View GL Account Details
To review the details of an account, select the underlined credit or debit value from the column in review and the details will display.
...
Sorting
Column sorting can be done by selecting the arrow icon to the right of the column’s name in the header row.
To hide a column from view, select Columns. Remove the check mark selection from the check box of the column to hide. Upon clicking away the unchecked column is now hidden.
...
To display a column that has been hidden, select the sort icon from any of the visible column headers. Select Columns. Check all columns you would like displayed.
Search, Export and Reload
...
Field
...
Description
...
Search
...
Search by account or value. Search only returns exact matches.
...
Export
...
Select the Excel icon to export the Summary into an Excel spreadsheet.
...
Reload
...