Submit a ticket

General Ledger Feed

Updated on Follow
0 out of 0 found this helpful

Note: To avoid losing real data, during testing/setup, back up the live general ledger data in your accounting software prior to importing any new test GL entries from Avionté.


Generate a GL Feed

  1. Navigate to Main Menu Back Office > Weekly Process.

  2. Click GL on the Shortcuts menu. The GL Feed Form displays.



  3. In the Date Range section of the GL Feed Form, enter a Start Date and End Date based on accounting period.

    • OPTIONAL: To clear prior journal entries, click Delete Journal Entry

      • Journal entries for the dates listed in the Start Date and End Date will be deleted.

      • If the journal has consistently balanced in previous accounting periods, there is no need to remove the journal entries.

    • OPTIONAL: Select the specific items in GL Entity that will be included in the GL Feed.

      Item Description
      GL Column Select the account columns that need to be included. The default setting includes all columns. Unselecting a column could cause the GL groups to not balance.
      Branch Select which branch/branches to include. To separate export files by branch, select one branch at a time and generate/export each result.  Creating separate feeds for each branch may also result in an imbalance in the GL groups.
      Entry Item This selection list does not impact the GL Feed or the Journal Entry results.


  4. Click Generate Journal Entry

    • All journal entries from the dates selected will be created on the Journal Entry Tab

    • Verify the journal entries balance per group in the Journal Entry tab (Debit Amount = Credit Amount)

  5. Return to the GL Action tab.

    • Ensure the Start Date and End Date are still listed correctly.

  6. Click Browse and select a folder/location where the GL Feed will be saved.

  7. Click Generate GL Feed. The feed will generate journal entries created for the selected date range with mapped accounts.

  8. Proceed with import within the external accounting software.

 


Field Definitions 

Field Definition
Accounts Receivable (debit) This sums the total bill from the time entry.
AP Check Payable (debit)  This sums the accounts payable net check amount.
AR Payments Received (credit) This sums the AR Payments.
Cash-AR Payments Received (debit) This sums the AR payments.
Discount (debit) This sums the discount amount from invoice.
Employer Taxes Expense (debit)  This sums the employer tax amount from the paychecks.
Employer Taxes Expense (credit) This sums the employer tax amount from the paychecks.
Finance Charges Asset (debit) This sums the finance charge amount from the invoice.
Finance Charges Revenue (credit) This sums the finance charge amount from the invoice.
Net Check Amount (Credit) This sums the net check amount for W2, 1099 and agency employees.
Sales Tax (credit) This sums the sales tax amount from the invoice.
Subcontractor Expense (debit) This sums the agency cost for non-W2 employees.
Total Adjustment in AP Checks (credit) This sums the accounts payable net check amount.
Total Sales (credit) This sums the invoice amount and the offset to this is the Accounts Receivable (debit).
Wages Expense (debit)  This sums the gross wages (taxable wages) for the W2 employees.
WC Expense (debit)  This sums the worker comp cost.
WC Payable (credit) This sums the worker comp cost.
Withheld Adjustments Payable (credit) This sums the employee taxes withheld from the paycheck.

 

 

Groupings and Offsets

Grouping Offset
AP
Debit AP Check Payable
Credit Total Adjustment in AP Checks
AR
Debit  Cash-AR Payments Received
Credit AR Payments Received
ERTaxes
Debit Employer Taxes Expense
Credit Employer Taxes Payable
Payroll
Debit

Subcontractor Expense

Wages Expense

Credit

Withheld Taxes Payable

Withheld Adjustments Payable

Net Check Amount

Sales and AR
Debit

Finance Charges Asset

Discount

Accounts Receivable

Credit

Total Sales

Sales Tax

Finance Charges Revenue

WC
Debit WC Expense
Credit WC Payable

Have more questions? Submit a request

1 Comments

  • Avatar
    Doug Gilbertson

    Can you please add the employer contribution to this page


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.