Content:
Configuration and Account Matching in SAGE in the Program
To create payroll using Excel with Sage/Peachtree, you must first make some adjustments in the program as detailed below.
1. In the Payroll module under the tax year you are working on, go to Settings.
2. Under the Import Templates tab, select Peachtree.
3. You must configure the SAGE account number with the corresponding payroll entry in the program.
There are several ways to match accounts:
- Manually: Download the template from your Payroll program (SAGE) and match the account number with the entry type.
- Import from the Previous Year: If you have already configured the accounts in the program in the previous tax year, you can use this option to bring over the account matching previously set up in the prior year.
- Import Excel Template: This option allows you to import all accounts directly from Excel. It is designed so that you can export the accounts from Sage, document them, and match the account type directly in Excel.
-
- After downloading, you must indicate the account number and then assign the account type. Accounts is the sheet for matching the accounts. Layout is the sheet where you can see the account types and their descriptions.
Once you have completed the matching in the Excel file, import the template into the program to configure the accounts.
SAGE Format
Once the account matching is configured in the program, you can import payroll Excel files in SAGE format into Expert Tax.
The columns PayFieldExpenseAccount and TransactionItemId are not required. However, you can add PayFieldExpenseAccount for reconciliation purposes. The program allows negative numbers with one exception: THE ACCOUNT BALANCE CANNOT BE NEGATIVE.
Importing Payroll Excel in SAGE Format
Before importing payroll Excel files in SAGE format, you must have already created or imported employees with their respective Employee ID in the program. In SAGE format, payroll entries are tied to employees by their Employee ID.
-
From the Home Panel, go to Add Data.
-
Choose Import Payroll from Excel.
3. In the box, upload the Excel file and then press Import.
Note: Make sure the Payroll Type is set to Peachtree.
If you need assistance, remember that you can request it through your Profile on our new Support Platform, and our staff will contact you as soon as possible. You can also reach us via our new email address at support@experttax.com.