https://help.ascendertx.com/interfaces/ 2026-05-02T05:27:45+00:00 https://help.ascendertx.com/interfaces/ https://help.ascendertx.com/interfaces/lib/exe/fetch.php/wiki/favicon.ico text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/1095c_offers_of_coverage?rev=1664551941&do=diff 1095-C Offers of Coverage File Layout This file record layout is used when importing a file to insert 1095-C insurance data records to the Personnel > Maintenance > ACA 1095 YTD Data > 1095-C page. SequenceField Length Type Description/Example1Employee Number or Social Security Number text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/auto_bank_reconciliation?rev=1664551941&do=diff Auto Bank Reconciliation File Layout This file record layout is used to import bank transactions. Field Length Position Type DescriptionBank Account Number121-12NumericLeft-Justified, Zero-FilledBlank 13-19 Check Number620-25NumericLeft-Justified, Zero-Filled text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_actual_hours_worked?rev=1664551941&do=diff Import Actual Hours Worked File Layout This file record layout is used to import actual hours worked data for variable hour employees. Field Length Type Example DescriptionEmployee Number6Numeric123=000123Required value; program will zero fillActual Hours Worked Date text/html 2023-12-11T20:27:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_annual_changes?rev=1702326463&do=diff Import Annual Changes File Layout This file record layout is used to import a text file to create, change, and delete employee deduction records. The file type is tab-delimited text and must have .txt in the file name. Sequence Field Length Description text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_cash_receipt?rev=1664551941&do=diff Import Cash Receipt Transactions File Layout Field Length Cash Receipt Number6Cash Receipt Number Description30Account Code20Cash Receipt Amount11Contra Offset Object4Contra Offset Sub Object2Cash Receipt Source/Description30 Notes: This is a comma-delimited file format, which means that commas are not allowed within a field. For example, there should not be any commas in the text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_changes?rev=1664551941&do=diff Import Changes File Layout This file record layout is used to import benefit changes on a weekly or period for active employees. Sequence Field Length Description1Employee Social Security Number91234567892Extract Deduction Code6123456; can be up to six characters; must match deduction code table text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_covered_individuals_data?rev=1664551941&do=diff Import Covered Individuals Data File Layout The Import ACA 1095-B/1095-C Data utility uses this file record layout when importing a file to insert covered individual data records to the Personnel > Maintenance > ACA 1095 YTD Data > 1095-B and 1095-C pages. text/html 2022-09-30T15:33:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_invoices?rev=1664552034&do=diff Import Invoices File Layout This file record layout is used to import a file to create invoice records. Field Length Type DescriptionCustomer Number6NumericRequired; must match a customer record in Accounts ReceivableRequested By35CharacterRequired if Customer PO Number is blank text/html 2023-11-29T20:49:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_jv_transactions?rev=1701290976&do=diff Import JV Transactions File Layout This file layout is used to import general journal transactions. [- Import JV Transactions Template] Field Length Class Codes Account Code20 Appropriation Amount116, 8Expenditure Amount116, 8Estimated Revenue Amount115, 7Realized Revenue Amount11 text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_staff_demo_insurance?rev=1664551941&do=diff Import Staff Demo Insurance Data File Layout SequenceField Length TypeDescription/Example1Employee Number or Social Security NumberEmp # - 6 or SSN - 9Numeric001511 or 1234567892Company Code5AlphanumericAetna3Plan Number20Numeric45667785594Plan Type1 text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/import_travel_check_transactions?rev=1664551941&do=diff Import Travel Check Transactions File Layout This file layout is used to import employee travel expense records. Field Length Position Type Description Vendor Number51-5NumericRequiredCurrent/Next16CharacterRequired; C for current or N for nextAccount Code text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/importcommoditycodes?rev=1664551941&do=diff Import Commodity Codes File Layout This file layout is used to import a list of commodity codes using a tab-delimited file. Field LengthType NotesGroup ID3Char If the value is zero (0, 00, or 000), then the column defaults to blank in the database. text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/merge_asset_management_text?rev=1664551941&do=diff Merge Asset Management Text File Layout This file layout is used when uploading Asset Management tables that were created from a separate software. Field Length Position Type Description Existing ASCENDER Item #101-10CharacterQuantity511-15Numeric text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/payroll_leave_transmittal?rev=1664551941&do=diff Payroll Leave Transmittal File Layout This file layout is used to import leave transmittal files into ASCENDER leave accounting tables. Field Length Type Position Description Employee Number6Numeric1-6123 = 000123Transaction Key6Numeric7-121st = 000001, 2nd = 000002 text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/payroll_transmittal?rev=1664551941&do=diff Payroll Transmittal File Layout This file layout is used to import payroll transmittal files into ASCENDER payroll transaction tables. Field Length Position Type Description Employee Number61-6Numeric123 = 000123Job Code47-10NumericLeft justified, if 123 = '123' text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/pncpositive_pay_export?rev=1664551941&do=diff PNC Bank Positive Pay File Layout This file record layout is used on the Finance and Payroll > Utilities > Positive Pay Export pages when using the PNC Bank Format option to export a fixed-width file specific to PNC Bank. DETAIL: Multiple records per account containing issue information for individual checks. text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/position_records?rev=1664551941&do=diff Position Records File Layout The Import Position Records page is used to import position records or distribution records into the position management tables. When importing position records, ensure the payroll frequency of the archived file is the same as that of the logged-on payroll frequency. text/html 2022-09-30T15:32:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://help.ascendertx.com/interfaces/doku.php/business/positive_pay_export?rev=1664551941&do=diff Positive Pay File Layout The record maximum is 100 characters. Any position (1-100) not used is recognized with a space. Field Length Position Type Description Account Number121-12NumericRight-justified, zero-filledVoid Indicator113NumericLiteral “