Cash Management Excel Workbook Import

New PRA System Feature: Cash Management Data Excel Workbook Import

Overview:

Cash Management individual financial instrument data can now be entered or copied/pasted into PRA pre-formatted Excel Workbook-Spreadsheet which then can be imported into the PRA System. This is a tremendous time saver for initially entering Cash Management data that exists in Excel originating from other database software (i.e. Access). As fast as the data can be copied and pasted the data can imported into PRA in minutes. This makes for easy tracking of financial instruments and projecting interest earned/accrued.

Excel Workbook Import Procedures:

First, an Analysis Date must be assigned before an Excel Import can be performed (a reminder box will appear if an Analysis Date has not been assigned).

From “Work Area Main Menu” select “Cash Management”, select “Import from Excel” from the “View Menu” and the “Import” menu and “Import” screen will appear with the following fields:

Description
Account No.
Initial Date
Maturity Date
Tax Free (yes/no)
Principal (amount)
Interest Rate (three decimals)
Compounded (monthly, quarterly, semi-annually, annually, daily 360 and daily 365)
Paid (per compounded or end of term)

To produce an Excel Blank Workbook, select “Blank Workbook” from the “Import” menu and an Excel Workbook will be opened with the fields above.

Data then can be manually entered or copied/pasted. When finished the Excel Workbook is saved (make it note where it was saved).

In the “Import” menu select “Import File” and the Windows browser will open. Find the Workbook and <click> OK. The data will now be visible in the “Import” screen. In the “Update” menu select “Apply Import” and the data will be imported to the PRA database cloud server.

Check the internal audit “Warnings” for any required data adjustments.


25 Years: The leading reserve management system since 1989.THE LEADING RESERVE MANAGEMENT SOLUTION SINCE 1989
for instant access to the PRA Free Trial
Live Demonstration

Register now to download a Live Demonstration of the PRA System to your desktop.

Registration is simple, you will immediately receive an email to confirm your email, then immediately receive access for downloading and installing the PRA System.

Register->


Limited Time Offer

Check out our promotions section to see if your group qualifies as a preferred customer.