Positivepay - How to integrate intacct with your bank account

Intact is a Cloud Accounting Software and web-based financial management software. Brittenford Systems has developed Positive Pay for Intacct, which allows your organization to automatically generate an electronic file of specified checks from Intacct to submit to your bank. The first step is to set up the file layout according to your bankÕs specifications. Banks often require: Header, Detail, and Footer Records, and sometimes require a Header Transmission Record. LetÕs take a look at how we have set up a Wells Fargo layout by looking at the Header, Detail, and Footer Record types. In the Header, we have set up the Output Type as Comma Delimited , but we could have also chosen Fixed Field or Tab Delimited. We have defined two fields for the record and a Total Number of Characters of 24. The two fields are defined within the record as a Constant Value and the Account Number. We can set up the Constant Value by choosing from a standard list of fields from within Intacct or choosing Constant and inputting our Constant Value. We define this field with a length of 6 and the Type and Format as Text. In the second field, we define it as the Account Number from our standard field drop down. Here we have added 8 Trailing Spaces and given it a Total Field Length of 18, with a Type and Format of Numeric. You see that we also could have chosen Date or Text for the Type. LetÕs take a look at the detail record. Again, we have established the Output Type as Common Delimited, with 6 fields, and a Total Number of Characters of 80. We define those 6 fields with different standard fields from within Intacct, ranging from Check Number to Payee. You can decide any of these standard fields to your Field Type and add any number of Leading and Trailing Spaces or Leading and Trailing Zeros. You can also set up Static Values for Void and Non-Void Indicators. Here we have established a Constant Value of 100 or 120 for Void and Non-Void respectively. Now letÕs take a quick look at the Footer Layout. In the Footer, we have again chosen Common Delimited, with 5 fields, and a Total Number of Characters as 33. In the Footer we have put a few constant values as Text, some filler spaces, and then a Summary Field. LetÕs take a look at one of the Summary Fields. Here we have chosen Total Number of Checks. You can also choose Total Number of Voided Checks, or Non-Voided Amount Totals, and Voided Amount Totals to include in your footers. The file layout configuration is a onetime setup for each checking account. Once it is complete, you are ready to generate files. LetÕs take a look at how we can easily generate files for this bank account. The first step is to put in a unique identifier for the file. Choose your bank account and define a Cutoff Date. The system will then generate a file of all those checks cut by your organization since the last time you generated a Positive Pay File. You can easily download the file to submit to your bank, or quickly open it to take a look. Here you can see our Header record has the Constant Value and Account Number as we defined, and each detail line has the 6 fields we defined. Thanks for taking a look at Positive Pay for Intacct with me today. For more information or to schedule a live demo, please visit the Brittenford SystemsÕ Website or send an email to sales@brittenford.com.