Preparing, Reviewing and Filing Estimate Back-End Files

Estimate back-end files are data files that include the estimate data due for each account for the current quarter. Estimate back-end files are transmitted to your trust accounting system using a three-step process: prepare, review and file. You can prepare, review and file federal and state, federal-only or state-only estimate back-end files.
Each account included in the back-end file has an indicator to designate whether its estimate is paid electronically or by voucher. An account is coded as electronic payments if the federal electronic estimate status is set to
Prepare and file electronic estimates
and the account is successfully enrolled in EFTPS. An account is coded as voucher payments if the federal electronic estimate status is set to
Voucher only estimate computation
. The allocation of the estimate between income and principal is also included in the estimate back-end file.
Estimate back-end files should be prepared, reviewed and filed before estimates are filed with the IRS or state taxing authority. This can help you:
  • Identify and verify the amounts that will be withdrawn from the accounts before the actual transmission and withdrawal occurs.
  • Identify accounts that may have been closed recently on your trust accounting system and that may have had an estimate calculated in error for the account. For those accounts, you can remove the account's estimated tax payment before estimates are filed with the IRS or state taxing authority.
note
If you do not file estimate back-end files during the estimates process, you can include estimate data in a tax history back-end file. To include estimate data in a tax history back-end file, select the
Include estimate payments from the tax return computation Do not select this if you send a back-end file for Electronic Estimates
check box when you prepare your tax history back-end file.
Some trust accounting systems accept an estimate back-end file transmission created by ONESOURCE Trust Tax, and some do not. If your trust accounting system does not accept back-end file transmissions from ONESOURCE Trust Tax, you can export the estimate back-end file. If you are unsure of which method to use, contact your Client Manager or your trust accounting vendor.
The
Can initiate electronic tax payments (EFTPS)
user right must be granted to you before you can prepare, review and file estimate back-end files.

Preparing an Estimate Back-End File

note
No TAV is currently setup through automatic transmission to accept a federal estimate back-end file for 990-PF accounts.
To prepare an estimate back-end file:
  1. Select
    HOME
    ,
    Admin
    then
    Estimate Payments
    .
  2. If you are preparing a federal-only estimate back-end file, select the estimate type from under the
    Estimate Type
    collapsible section. The default selection is
    1041
    , and is used to prepare a federal estimate back-end file for 1041 accounts. The
    990-PF
    selection is used to prepare a federal estimate back-end file for 990-PF accounts.
  3. Under the
    Prepare and File
    collapsible section, select Run in the
    Prepare
    column for the estimate back-end file you want to prepare.
  4. A message displays, asking if you want to automatically send the back-end file to your TAV.
  5. Select
    Yes
    to automatically send the file after the preparation process completes. The file is not sent to your TAV if the preparation process completes with errors. Select
    No
    to prepare the file without sending it to your TAV.
  6. A request is initiated that determines the taxpayers and their payments for the filing. Initially, the
    Preparing Status
    column displays
    Preparing
    , but will indicate if any issues are detected in the request. To see whether the processing status changed, select
    Refresh
    or Refresh grid data at the bottom of the grid. If no errors are detected in the finished request,
    Complete
    displays in the
    Preparing Status
    column and File displays in the
    File
    column.
  7. If
    Complete with errors
    or
    Needs Attention
    displays, use the Request Status and History page to review the errors. On this page, the errors associated with
    Complete with errors
    display under the
    Request Errors
    collapsible section, and the errors associated with
    Needs Attention
    display under the
    Current Events
    section.

Reviewing an Estimate Back-End File

To review an estimate back-end file:
  1. Select
    HOME
    ,
    Admin
    then
    Documents and Data Files
    . The Documents and Data Files page shows the PAN level documents and data files for all types and all years.
  2. Locate the estimate back-end file you prepared in the applicable tax year category and estimate filing subcategory. 990-PF estimate back-end files are included in the
    Folder: Estimate Filing-EFTPS 990-PF Estimate Payments
    subcategory. The description for an estimate back-end file indicates that the file is for updating the accounting system.
  3. Select the
    File Name
    link for the estimate back-end file. A message displays, asking if you want to open or save the file.
  4. Complete one of the following:
    • Select
      Open
      to open the file. WinZip opens. You can extract the data file or double-click it to open the Internet browser associated with the .XML extension and display the file's contents.
    • Select
      Save
      to export the file. The Save As screen displays. You can change the file name and save the file to the location you want to save it.
  5. Review the details of the estimate back-end file to ensure the taxpayers and payment amounts are correct. If you notice an error, correct the source taxpayer information or payment amount, reprocess the account's estimates then prepare the estimate back-end file again. You can prepare an estimate back-end file as many times as is needed to ensure the taxpayers and payment amounts are correct.

Filing an Estimate Back-End File

note
No TAV is currently setup through automatic transmission to accept a federal estimate back-end file for accounts that are private foundations filing Form 990-PF.
To file an estimate back-end file:
  1. Select
    HOME
    ,
    Admin
    then
    Estimate Payments
    .
  2. If you are filing a federal-only estimate back-end file, select the estimate type from under the
    Estimate Type
    collapsible section. The default selection is
    1041
    , and is used to file a federal estimate back-end file for 1041 accounts. The
    990-PF
    selection is used to file a federal estimate back-end file for 990-PF accounts.
  3. Under the
    Prepare and File
    collapsible section, select File in the
    File
    column for the estimate back-end file you want to file. One of the following happens:
    • If your back-end files are electronically transmitted to your trust accounting system, File in the
      File
      column changes to Filing complete, and the
      Filed
      ,
      Date Filed
      and
      Filed By
      columns are updated to indicate that the filing for the estimate back-end file is complete.
    • If your back-end files are not transmitted electronically, the filing is marked as completed on the Estimate Payments page and the Documents and Data Files page.
note
In the
Prepare
column, Run is always available so you can prepare and file multiple estimate back-end files.