This Help File Page was last Modified on 12/07/2018

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > Receivables - File Menu Options > Post Auto Drafts >


This Help File Page was last Modified on 12/07/2018




This Chapter is still being revised!



 File Type:  Drafts Bank Accounts and Credit Cards

 -  Requires no setup as far as Client ID or account number.  Users log into portal to upload.

 -  Produces Comma Delimted File

 -  Output Fields

         1.    InvoiceHeader.InvoiceNumber

         2.    Description String - "Recurring Revenue For Month 'AutoDraftMonth' Year 'AutoDraftYear' Cycle 'TheCycleBeingRun'

         3.    InvoiceHeader.BalanceDue

         4.    TransactionType - "CC" for Credit Card, "ECHECK" for Bank Account

         5.    Subscriber.AccountTransType - Personal Checking = "PPD"  Business Checking = 'CCD'

         6.    Hard Coded Value = "AUTH_CAPTURE"

         7.    BLANK

         8.    Subscriber.CardNumber - (if Credit Card Transaction ... otherwise blank)

         9.    Subscriber.CardExpiryDate - Format (mmyy - ie 0118)

         10.  Subscriber.BankAccountNumber (if Bank Account Transaction ... otherwise blank)

         11.  Description String - 'BUSINESS CHECKING', 'CHECKING', OR 'SAVINGS' based on value stored in Subscriber.AccountTransType

         12.  Subscriber.RoutingNumber

         13.  Subscriber.BillPayer

         14.  Subscriber.SubscriberName

         15.  Subscriber.AddressStreet

         16.  Subscriber.AddressCity

         17.  Subscriber.AddressState

         18.  Subscriber.AddressZip

         19.  Subscriber.PhonePrimary

         20.  Subscriber.PhoneFax

         21.  Subscriber.Email



When your Company selects Authorize.Net as the File Type to be used for Auto Draft Processing, the options available to be selected are:



Post Auto Drafts - Authorize.Net selected


Period To Post - Define what Recurring Billing Period is being processed for Pre-Authorized Auto Drafts.

Year - Use the Drop-Down Selection List to Choose the Year that is being processed for Pre-Authorized Auto Drafts.

Month - Use the Drop-Down Selection List  to Choose the Month that is being processed for Pre-Authorized Auto Drafts.

Cycle - If the Multiple Billing Cycles feature has been implemented, use the Drop-Down Selection List to Choose the Recurring Billing Cycle that is being processed for Pre-Authorized Auto Drafts.



Post Auto Drafts - Authorize.Net options


Batch No. - By default, it will be the calendar number of Today. Change this Batch Number, as needed.

Bank - The correct Bank Name will be automatically inserted based on the Bank assigned to the selected Recurring Billing Cycle.

Pay Date - By default, it will be Today

Use the Drop-Down Calendar/Date Entry field  to Choose the Date these Invoices will be marked as Paid within the Accounts Receivable System.

This Pay Date should be on or after the Draft Date entered next.

a)Click on the Date field and type the desired Date using a MM/DD/YYYY format; or

b)Use the Drop-Down Calendar/Date Entry field provided to Choose the desired Date

Draft Date - By default, it will be Today

Use the Drop-Down Calendar/Date Entry field to Choose the Date that these Amounts will be Withdrawn (Drafted) from the Subscriber's Bank account, and/or Charged to their Credit Card.

This Draft Date should be on or before the Draft Date entered prevously.

Generate EFT File - You will need an EFT file generated, so Click this Generate EFT File? box.

File Type - Use the Drop-Down Selection List to Choose the Authorize.Net EFT system.

Post Credit Cards? - If this Auto Draft process should post both EFT Cash Deductions and Credit Card Charges, Check this box.

Credit Card Batch No. - If Post Credit Cards? was Checked, this field will be activated and will become a mandatory entry.

Use separate batch number for Credit Cards? - Click Yes and enter the desired Batch Number below.




Credit Card Batch No. - By default it will also be the calendar number of Today.  Enter the desired Batch Number, as appropriate, which may (usually will) be different than Today.


Create Payments? - Normally the Post Auto Drafts process:

a)Creates a Receipt record; and

b)Allocates that Receipt to the appropriate Recurring Revenue Invoice

c)When (if) an Auto Draft attempt fails for any reason, the User is required to Unallocate and then Delete that Receipt record.  


However, this Authorize.Net Auto Draft processor will return a Payment Import file which reports and records the Receipts that processed successfully, and will automatically Allocate those Receipts when requested to do so.

Check this Create Payments? box only of you want to create the Receipt records in advance.


Understanding the Authorize.Net File Format

File Type: Authorize.Net - For EFT Drafts Bank Accounts and Credit Cards

Requires no setup in a Bank Maintenance record (e.g., Client ID or Account Number) because the User logs into their portal to upload the Auto Draft file.

Produces a Comma Delimited text file.


Auto Draft file's Output Fields

a)Invoice Header>Invoice Number

b)Description String - "Recurring Revenue For Month 'Auto Draft Month' (e.g, 'August'); Year 'Auto Draft Year' (e.g., '2018'); Cycle (e.g., 'Week 3').

c)Invoice Header>Balance Due

d)Subscriber>Draft Type - "CC" for Credit Card, or "ECHECK" for Bank Account

e)Subscriber>Account Type - Personal Checking = "PPD"  Business Checking = 'CCD'

f)Hard Coded Value = "AUTH_CAPTURE"


h)Subscriber>Account Number - (if Credit Card Transaction ... otherwise BLANK)

i)Subscriber>Card Expiry Date - Format mmyy (e.g., '0118')

j)Subscriber>Account Number (if Bank Account Transaction ... otherwise BLANK)

k)Subscriber>Account Type - Description String = 'BUSINESS CHECKING', 'CHECKING', OR 'SAVINGS' based on value stored in Subscriber>Account Type

l)Subscriber>Routing Number

m)Subscriber>Bill Payer

n)Subscriber>Subscriber Name

o)Subscriber>Address Street

p)Subscriber>Address City

q)Subscriber>Address State

r)Subscriber>Address Zip

s)Subscriber>Phone Primary

t)Subscriber>Phone Fax



Populate the below columns in the Authorize.Net file with valid data from your database [b) and c) should be fine to run a test.].

Run the import with the populated file.  

Expected result is for the receipts that are generated to be applied to the invoice numbers populated in the file.


Column 4 -  TransactionID (Populate w/Numeric data, can be random data)

Column 8 -  InvoiceNumber (Populate w/a valid open invoice)

Column 10 - Total Amount (Populate w/dollar amount, preferably the same amount of the open invoice. DO NOT INCLUDE CURRENCY SIGN)

Column 11 - Method (Payment method valid values are A,D,E,M,V)

Column 13 - CustomerID (populate with w/valid Bill Payer ID for the Invoice)