General Ledger Module
The General Ledger Module in PestPac allows certain transactions to be recorded and then be exported into a format that is compatible with your accounting software.
Throughout PestPac, users can track GL by setting up GL codes and assigning them to customers or services. PestPac then tracks all the
transactions behind the scenes. At the end of the month, period or year, users can then export and release GL transactions for accounting purposes. You can then import the file into your accounts software.
Although Quickbooks will be used throughout the tutorial as an example, The General Ledger module can be used with other accounting software applications, like PeachTree. If you require assistance with your
General Ledger Module
By the end of this tutorial, you will be able to:• Set up the appropriate Lookup Table and Company Setup options
• Be knowledgeable about every area in PestPac that the General Ledger is used
• Release and export the General Ledger file to your accounting software
General Ledger Module
Enter the name of the new GL Code along with the Sales, A/R, Cash, Sales Tax and
Define a Default GL Code that will be used for all new customers or services. Define a GL Suspense Account to be used when the program is unsure of which GL code to use. The
Define where you want the Sales Code to come from—either the Customer or the Service. If you are using the Service option, you must assign a GL Code to each service in the
You have the option to lock the GL Codes. If the GL Codes are locked, users will not be able to change them manually on service orders, setups or locations.
You also have the option to use the GL code from the method of payment in the payment screen. If this option is selected, you will need to enter a GL Code in each Method of
Click on each service to assign a GL code to it. The GL code you are assigning to each service will be used to determine what Sales account is effected when an invoice is
General Ledger Module
GL Codes can be entered in the following areas in PestPac:
•
Location Detail Screen
•
Service Setups
•
Renewals
Location
At the bottom of the Edit Location screen, you can specify a GL code that will
Service Setups
The GL Code defaults from the Location and determines the A/R, Cash, and Sales Tax accounts.
Renewals
The GL Code for the Sales account can be entered here
The GL code for the A/R, Cash, and Sales Tax accounts is entered here for invoices or
Service Orders
The GL Code for the Sales account can be entered here
Payments
General Ledger Module
Once the batch is released, you will see a link to a text file (.txt) and a file specific to
General Ledger Module
General Ledger Module
Example 1
1) Post a service order for a service and the customer is billed for that service:
Accounts Receivable +$ 82.00
Sales -$ 80.00
Sales Tax Payable -$ 2.00
2) Customer pays for the service from the example above:
Cash +$ 82.00
3) Have to refund money from customer in Step 1 and enter in a reverse payment.
Accounts Receivable +$ 82.00
Cash -$ 82.00
4) Void Invoice from Step 1
Sales +$ 80.00
Sales Tax Payable +$ 2.00
General Ledger Module
Example 2
Create a credit memo
Sales $ 100.00
Sales Tax Payable $ 6.00
General Ledger Module
Example 3
Entering in a renewal payment
1) Creating the invoice:
Accounts Receivable $ 200.00
Sales -$ 190.00
Sales Tax Payable -$ 10.00
2) Entering in the payment:
Cash +$ 200.00
General Ledger Module
Example 4
Creating an adjustment
Discount Account +$ 50.00
