Create a macro to create Positive Pay bank file from Check Register
I'd like to have a macro that would put check register information into a format that is appropriate for uploading to the bank for Positive Pay or check clearing verification.
1
vote
Becky Schroeder
shared this idea
Declined
·
AdminLeAnn M Hillman
(Product Manager, Fusion Laboratories, LLC - NPact Endowment Manager, Grant Edge NXT, Spectrum NXT)
responded
AdminLeAnn M Hillman
(Product Manager, Fusion Laboratories, LLC - NPact Endowment Manager, Grant Edge NXT, Spectrum NXT)
responded
The check register in FIMS can be saved as a text file and then opened in Excel. Once opened in Excel, the data can be formatted correctly.
Here is an example of how to format data for Positive Pay from a third party source that may be useful:
Create Positive Pay Files from Excel/csv files (treasurysoftware.com)