The screen includes AP Payments and Advances that have been entered, approved and completed through the standard Sage Intacct processes, for vendors where the EFT File Format is set on the Orchid EFT Tab. Payments made for Credit Card and Savings banks are excluded.
How to Use the screen
You can use this screen to select payments to be included in an EFT File or to view the payments already included in a file.
To create a new EFT File
By default, the screen shows completed posted payments for vendors configured for EFT that are not in any EFT File.
Select the payments you want to include in an EFT File.
In the bottom right corner of the screen, you can view the number of records and the running total of the selected records to assist in validating the records selected against control total.
You can then GENERATE the EFT file. Refer to Generate EFT files
To view payments in a file
For details on using the screen to view Payments in a file, refer to View AP payments in EFT File.
Step 1. Complete AP Payments using standard Sage Intacct processes
You need to create the AP Payments using the standard Sage Intacct processes. EFT Processing can include completed posted payments for any payment methods (Record Transfers, Checks/Cheques, cash and Advances).
Using Record Transfer payment method
Record Transfer is commonly used when you want to generate EFT Files for the payments.
You can use other payment method for payments that don't require an EFT File and filter by payment method on the AP Payment request screen.
Note: There is no feature to auto-number Record Transfers, so you need to copy the memo field and add digits to make the document number unique manually.
Using Check payment method
If you are doing Checks, you need to print the checks for the payments to be posted. You can then include the payment in a positive pay EFT File as required by the bank.
Using ACH/Bank File payment method
If you use ACH or bank file, Sage Intacct creates separate payment records. You need to create, download and confirm the EFT File with the Sage Intacct standard process as this is required to post the AP Payments.
Note: Do not upload the standard file to the bank.
Posted payments are then available on the AP Payment Request screen to generate a new file using Orchid EFT Processing and the required format.
Use ACH Payment method if the standard process EFT File format is not compatible with your bank's requirements, but you want to use some of the standard process's features to number payments:
-
Users are prompted for a “payment reference” which gets copied to “memo” on the payment when they select an invoice to be paid an
-
auto-numbering of the Doc No. on the payment.
These fields can then be used in the bank reconciliation.
Payment approval and processes
-
If approval is enabled in your site, you need to approve the payments. Once approved, they are posted and available on the AP Payment Request screen.
-
You can use Pay Now or Outbox depending on your process. Payments in the Sage Intacct Outbox are not included in the EFT AP Payment Request list. You need to pay the bill on the Outbox, approve and post the payment as per the standard process.
Step 2. Add Records to Generate an EFT File
Select not in any EFT File to view payments available.
Use the tick box next to Vendor ID to select/deselect all records.
You can also select payments individually.
Note: If you can't find a payment you want to pay, check that the vendor is configured for EFT and that the payment is confirmed and posted.
Note: If the Format is crossed out, it generally means that the bank is not configured for the selected format. Hover over the field for a description of the issue.
Step 3. Generate EFT files
Use the Generate button to create EFT Files for the selected payment records. EFT Processing creates one file per bank and per EFT File Format for the selected records.
Note: If there are any validation errors, review the message, update the required data and try generating the file again.
Tip: The screen displays "In Progress" messages to indicate that processing is yet to complete.
Tip: EFT Processing displays a message with the number of files generated.
Filtering records
Tips when using filters:
-
The screen filters to 1 month ago by default.
-
Filters are saved from a prior session in the browser.
-
If the column heading is in italic, it means there is an active filter. Check the filter if you can't find the records you are looking for.
Fields available to filter by:
-
You can filter by any fields on the first row, by selecting from the list of values or using a filter string.
-
Vendor/Customer/Employee Types and Payment Created by are available to use as filters.
When working at Entity Level in Sage Intacct
If working in Sage Intacct at the Entity Level, the only shows the user name for payments created by the logged on user. The payment is displayed in the list, but the field is blank.
If you have security rights at the top level, you can view and filter by the name for all users.
View screenshot
Filtering records with a filter string
You can type a filter criteria, using =, >=, > or < for most fields.
Example: To filter by amount, enter >500 only, do not include the currency
Select Records from the list
Click in one of the fields in the first row to display a box with the values you can select.
In the EFT Payment Request screen, to filter by Payment Method, click in the Payment method field. This displays all values and you can select the values required, for example "Printed Checks"
You can also filter by typing text in the box. If you don't want to view Printed Check, you can filter them out using !=Printed Check in the Payment Method
-
To filter by amount, enter >500 only, do not include the currency
-
If you don't want to see Printed Check in the Payment Request list, you can filter them out using !=Printed Check in the Payment Method
Sorting Records
You can sort most columns by the column heading, by clicking on the column heading.
When you hover over the heading in a list, the cursor changes to a pointing finger and you know you can sort. This is consistent with the standard Sage Intacct screens.
Drilldown to AP details
Drill down to view AP Vendor details by clicking on the .
Drill down to view the AP Payment Details by clicking on the field.
Next Steps - EFT File List
You can then view the files created in the EFT File List. Refer to EFT File List for details.
Troubleshooting
EFT AP Payment Request Troubleshooting
Step 4. View Payments in a file
You can use this screen to view the payments already included in a file.
