This Help File Page was last Modified on 12/07/2018
This Help File Page was last Modified on 12/07/2018
* INSTRUCTIONS FOR AUTHORIZE.NET PAY IMPORT *
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
2. Description String - "Recurring Revenue For Month 'AutoDraftMonth' Year 'AutoDraftYear' Cycle 'TheCycleBeingRun'
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"
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
❑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.
•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
✓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
•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)