Charitable Funds 3.145 From 64-11-2009 Intranet Statements Format of numbers changed Size of Transaction details field increaded Charitable Funds 3.140 From 24-4-2009 Gift Aid Export Added Charitable Funds 3.138 From 4-3-2009 Added routine to clear Budget values Charitable Funds 3.137 From 14-1-2009 Gift Aid Report Changed Charitable Funds 3.136 From 27-10-2008 Added Fund Purpose to Balances Export Charitable Funds 3.135 From 16-9-2008 Import Function added to Batch Input Menu. Please call us for a copy of CFundImp.xls Charitable Funds 3.134 From 11-9-2008 Exclusions report adjusted to check imported approval fund matches the approvals fund Charitable Funds 3.133 From 10-9-2008 Statement Layout amended to move description to the left, journal field made smaller. Charitable Funds 3.132 From 10-8-2008 Alert on data transfer removed. Charitable Funds 3.131 From 7-8-2008 Option added to remove inverted commas from descriptions. Charitable Funds 3.130 From 9-5-2008 Option added to remove inverted commas from descriptions. Charitable Funds 3.129 From 2-5-2008 User History Transaction Deletion routine added to Year End Menu (Administrators only) Charitable Funds 3.128 From 22-4-2008 Gift Aid Edit - Flag on screen and updated/cleared when name and address is added/deleted. Charitable Funds 3.127 From 11-2-2008 New export added to OS Approvals Report. Charitable Funds 3.126 From 6-2-2008 New screen added (from main menu to allow edit of Gift Aid Name address. Charitable Funds 3.125 From 6-2-2008 Payments - New report - Paid Dates Blank Periodic Statements - Print Button matches Preview Button Charitable Funds 3.124 From 24-1-2008 Purchase Invoices - Automatic removal of inverted commas from descriptions (they are replaced with two apostropes so there is no visual difference) Charitable Funds 3.123 From 11-1-2008 BACS Name field size increased to 40 Investments: Check for division by zero added. Charitable Funds 3.122 From 6-11-2007 Invoices - Entry Order Adjusted Charitable Funds 3.121 From 3-11-2007 Report added to Payments screen - Print Transaction Details Charitable Funds 3.120 From 18-10-2007 SoFa Transfer - Split of Suspense A/C Retained on transfer Charitable Funds 3.119 From 1-10-2007 Batch Transfer - Alert on transfer Removed Charitable Funds 3.116 From 28-8-2007 Managers Report indexes - New reports Sort order and selection Batch Input - Warning if Approvals Payments uses a fund from a different group to the control account Charitable Funds 3.115 From 23-8-2007 BACS Details added to suppliers table BACS Details read from suppliers when payment is created Export Supplier details added Charitable Funds 3.114 From 22-8-2007 Balance List Columns Adjusted. Charitable Funds 3.113 From 16-08-2007 Apportionment Exclusion Field Added Charitable Funds 3.112 From 26-04-2007 Automatic Allocation reports Title adjusted. Charitable Funds 3.111 From 20-04-2007 Export Balances - Full Export - Gift Aid Names Included. Charitable Funds 3.110 From 08-01-2007 Gift Aid Report selects only gift aid receipts not all receipts. Charitable Funds 3.109 From 01-11-2006 Administration Allocation Routine. - Period/Year Calculation amended Charitable Funds 3.108 From 12-10-2006 New reports added to Purchase Invoices Option Checks added to Purchase Invoices to prevent postin an incorrect code type against the fund account used. Option Added to periodic balance report to export data. Charitable Funds 3.107 From 08-09-2006 Periodic Statements Routine adjusted. No longer requires exclusive access. Charitable Funds 3.106 From 22-08-2006 Exports from funds now allow the user to select the location of the exported file. Charitable Funds 3.105 From 31-07-2006 Automatic Allocations are now restricted to individual groups. Charitable Funds 3.104 From 27-07-2006 Invoicing screen jumps to Surname after no account. New Report showing last transaction date SoFA and Balance Sheets show group number on footer Charitable Funds 3.103 From 19-07-2006 Increased on screen size of Supplier Name in Suppliers Enabled Editing of VAT amount in Payments screen Call VAT Account from Company details in Payments Screen Charitable Funds 3.102 From 14-07-2006 Preiodic Statements Amended Index adjusted on Purchase Invoices - Supplier Name - Reference added as sub index Charitable Funds 3.102 From 14-07-2006 Periodic Statements Amended Index adjusted on Purchase Invoices - Supplier Name - Reference added as sub index Charitable Funds 3.101 From 19-06-2006 New Field added to Purchase Invoices Screen - Supplier Name New Routine added to Purchase Invoices Screen - Re-Process all Supplier Names New feature added to Payments - Find Invoice Entry Order changes on Payments screen Entry Order changes on Purchase Invoices screen Charitable Funds 3.100 From 13-06-2006 Presented Date Button activated on payments screen. Charitable Funds 3.99 From 05-06-2006 Reversal Journal Identification on main transaction screen. Statements - Default layout - Description field wider and right aligned. Charitable Funds 3.98 From 24-05-2006 Gift Aid Names and Addresses now transfer from Batches New Gift Aid report Added Invoice field size increased Purchase Invoice comments field size increased SoFA Administration - Balance sheet items can be edited Charitable Funds 3.97 From 28-04-2006 Statements with Approvals - Print to Printer button matches the report on Screen View button. Charitable Funds 3.96 From 25-04-2006 Transfer of Journal Batches now sends the reversal batch date one day after the original batch. Charitable Funds 3.95 From 20-04-2006 Periodic Balance List Adjusted Charitable Funds 3.94 From 07-04-2006 Payment5 cheque layout adjusted. Charitable Funds 3.93 From 04-04-2006 Details transferred from Purchase invoices re-organised. Charitable Funds 3.92 From 30-03-2006 Purchase Invoice - VAT now able to over-ride calculated amount. Invoices layout amended. Charitable Funds 3.91 From 9-03-2006 Payments Screen shows transferred date. Transfer Routine for one-off payments amended Field for Cheque Signature added to Company Details Charitable Funds 3.90 From 24-02-2006 Purchase Invoices - Make Payment button removed. The routine has been moved to the Transfer Details pull down menu --> Transfer invoices to payments. Charitable Funds 3.89 From 10-02-2006 Assets Unit value on movements increased number of decimal places Purchase Invoices Bank account and Accounts Code auto-filled Purchase Invoices Payment date not filled in automatically Purchase Invoices Screen layout adjusted Purchase Invoices Transaction New Field added to comments Payments Transaction reference now allows manual input Payments Jump past the reference if other selected Payments Supplier pick now in alpha order Payments Batch print of cheques Payments New Cheque format added PAYCHEQ5 to Company Details Managers fund viewing screen added - Icon needs to point to CFUNDSVW.JCL instead of FIRST.FRM Budgets Groups added Budgets Groups field added to income and expenditure codes Budgets Groups now updated by budget group and not I&E Code if codes selected. Charitable Funds 3.88 From 03-02-2006 Export of assets added Charitable Funds 3.86 From 18-01-2006 Group Warning on Bathc input - If fund belongs to a different group FIRST1.FRM as an alternative to FIRST.FRM (No screen delay) New Button added to Bathc input Screens. "Insert Approval Payment". This allows the selection of an approval and to read in the account number from the approval. Approval Description added to the Batch Input screens. If a gift aid letter is printed then gift aid flag is automatically set on transaction. Charitable Funds 3.85 From 22-11-2005 Routine Added to correct changes of Fund Restriction Type Charitable Funds 3.85 From 9-11-2005 New routine to export Income and Expenditure to Excel Charitable Funds 3.84 From 27-9-2005 Adjusted the import from payments to ensure the correct year is identified when more than one payment is made to a supplier. Charitable Funds 3.83 From 10-9-2005 Indexed Approvals OS Value as a pick button Charitable Funds 3.82 From 1-9-2005 Screens for 1024 x 768 resolution - Please call for instructions on use. Charitable Funds 3.81 From 3-6-2005 Rounded Balance Sheet - Previous year values added. Charitable Funds 3.80 From 3-6-2005 Periodic Statement Routine Adjusted. Charitable Funds 3.79 From 25-5-2005 New routine added to year end menu to refresh/recalculate brought forward balances and to automatically apportion the BF split to control accounts Charitable Funds 3.78 From 20-5-2005 Automatic Allocation routine changed. Charitable Funds 3.77 From 18-5-2005 SOFA / Balance sheet total fields increase in size. Charitable Funds 3.76 From 6-5-2005 Periodic Statement Selection Amended Charitable Funds 3.75 From 27-4-2005 SoFA and Balance sheet reports - Number format shows commas and brackets for negative values Charitable Funds 3.74 From 29-3-2005 Special Request - Routines for data import Charitable Funds 3.73 From 28-2-2005 New routine to adjust transactions posted to wrong year. Charitable Funds 3.72 From 28-2-2005 Automatic Posting Routines - New calculation applied. Charitable Funds 3.71 From 8-2-2005 Automatic Posting Routines - New calculation applied. Charitable Funds 3.70 From 19-1-2005 Intranet Statements- Manager summary pages now have approvals and available balance details Charitable Funds 3.69 From 05-1-2005 Amendment to layout of PAYCHEQ4 New routines for calculation of Administration Charges (for testing) Please call if you use these routines before the next upgrade. Charitable Funds 3.68 From 05-11-2004 Created date added to the intranet managers index page Charitable Funds 3.67 From 02-11-2004 PAYCHEQ2 cheque print layout amended. Amended the automatic posting routines. Allows dates selection where final date is before the date of entered transactions. Charitable Funds 3.66 From 22-10-2004 Added new field to Company Table to identify Charity Reference Number (If not already identified in the Company No Intranet Statements adjusted to include Approval Statements FIeld added to Company to identify different Gift Aid Letter Formats
Charitable Funds 3.65 From 27-9-2004 Added new field to Users to identify if the printer is to be selected Option added to Balance list for Departments to ask if a page break is required. Added a hidden routine to allow easy conversion from restricted to unrestricted all funds and double entries (Please call us if you need to run this routine).
Charitable Funds 3.64 From 14-8-2004 Added new field to Funds to identify that the fund is closed. Entries made against closed funds are now forbidden. Added to the payments transfer the goods description to the payment name to make up the description transferred to the batch.
Charitable Funds 3.63 From 28-7-2004
Batch Input: New field added to remember the previous I&E code used in the batch. This will be used in the next transaction. New option to specify that the batch is to create a double entry for all transactions instead of a single double entry for the batch. Useful for recording details of all payments in a batch as single entries in the bank account, thereby making the bank reconciliation easier. Added an option on automatic posting of administration apportionment to ask for the Income and Expenditure code to be used during the posting. The SoFA report has been adjusted to make it print out on one page. Messages: Adjusted the temporary location of all sent messages.
Charitable Funds 3.62 From 15-7-2004 Password field increaed to 20 characters
Charitable Funds 3.61 From 21-6-2004 New Cheque Remittance Advice Layout added PAYCHEQ3 to company details Amendment to Brought forward Screen to recalculate Debits and Credits in current year. Charitable Funds 3.60 From 26-5-2004 Index reports in name and account order can now select all accounts or funds only.
Charitable Funds 3.59 From 11-05-2004 Automatic posting routines have been amended to allow the user to pick the current date, the year end date or a user input date as the date of the batch. This allows the user to allocate spread amounts at a date in the new year but back date them to the old year without having to remember to change the batch date. Added two indexes to batch input to allow viewing of transactions in a batch in entry order and reverse entry order. Audit trails have the details field extended and are now right aligned.
Charitable Funds 3.58 From 27-04-2004 Allocation of administration charge routine amended to correctly split the double entry by fund types.
Charitable Funds 3.57 From 13-04-2004 Added Field to identify if Gift Aid Letters are to be produced in Batches.
If Gift Aid Letters are to be produced then a letter will be created from a name and address field entered against the transaction in the Batch. Payments: Added Authorisation list for all unprinted cheques. Payments: Added report to print out all unprinted cheques in a batch. Charitable Funds 3.56 From 08-04-2004 Index for Funds showing Managers associated to each fund. Batch Input - Fund Account number pick - Added selection of funds by Fund Name as well as Account number Fund Input Screen - Manager Code pick - Change the sort order on the pick to Surname (From Account Number) Company Details - Added default code for Payments double entry. Payments - Reads in the Company double entry payments code. Payments - Jumps to the transactions immediately after save for faster input. Payments - Default index now payment reference. Payments transfer routine - Incorrect year corrected
Charitable Funds 3.55 From 02-04-2004 Batch Validation Reports added Financial Period and Split Values. Import routine for automatic postings creates the correct year.
Charitable Funds 3.54 From 05-03-2004 Added Fund Purpose field to funds. Show fund purpose on Approvals Screens Details entered in batches, transactions and approval descriptions have inverted commas replaced with two apostrophes. Charitable
Funds 3.54 From 19-02-2004 Added an option to the exports menu "Create Audit Reference Check File". This will export all data sorted by Reference 1 and export only the Reference 1, Total Debits and Total Credits. An Excel formula will be copied to your clipboard. Open the file created in Excel as a delimited file and make sure that comma is selected as the delimiter. Paste the formula into R1 CD and the copy the formula down all the other rows in Column D. This will then highlight and batches where the total debits do not equal the total credits. Charitable
Funds 3.53 From 19-02-2004
Added a report to the extras menu to select transactions where the transaction period appears not to relate to the transaction date. Added an option to exclude the excluded transactions from the trustees reports.
Charitable Funds 3.52 From 23-01-2004 Descriptions added to Company Table to rename Directorate, Hospital and Department. Adjustments to reports and screens will be completed over a period of time. If you spot any omissions or require a particular report updating then please contact us immediately. Page footers for all SoFA and Balance sheet reports now have page numbers, date and time.
Charitable Funds 3.51 From 02-12-2003 Current Balance Report Adjusted - Directorate Sort/Subtotal replace with a BF Code Sort/Subtotal report. If you still require the directorate report please call us. New transaction group added to Approvals for Notes. Notes action dates will appear on the reminder on the main menu. Balance Sheet and SoFA reports show total lines in bold New Report in managers table to show all funds and limits for each manager. BF Code defaults to 600 when new accounts/funds are inserted. Background colour added to company table in preparation to identify split systems. Logout time added to user table. This time is minutes is the delay from last use to automatic close down of the system. Defaults to 2 hours if no time is entered.
Charitable
Funds 3.50 From 03-11-2003 Added Option in Batch Transactions to check periods (used when importing data from external systems).
Charitable
Funds 3.49 From 28-10-2003 Added next payment reference number to Company Details Screen. Added a new field to identify which cheque payment layout should be used. Charitable
Funds 3.48 From 17-10-2003 Added option to e-mail letters. Amended the Check for Blank Periods (missing preceding zeros) so the routine will now also check for missing dates and missing period and years. Charitable
Funds 3.47 From 17-9-2003 Licence: renewal warning extended to 21 days. Automatic Posting Routines. If the Batches are set to automatically number in the Company details then the batches will now take the next number. Extra Transaction groups added for Notes and Correspondence. New table for Standard Letters New table for Letter Fields. Call for codes to be imported. Notes Action Dates Report Added Reminders (Notes with an Action Date) will be checked each time the Menu is accessed. Charitable Funds 3.46 From 7-8-2003 Added extra value to Posting Rules "Fields
to Use" - "Carrying Value Loss / Gain" Added deletion options to all transactions in the investment register, only if the details have not been posted to the ledger and if the transaction is the most recent transaction entered. Please ensure that all transactions are entered in chronological order otherwise inaccuracies will occur in your data.
------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- Amendment to the transfer to notes screen allowing multiple codes to update an individual line/cell on the Excel Notes Adjustment to Periodic Balance Report including approvals.
Automatic Postings Routines - Reports changed to show the Current Balance and the effect of the allocation calculated in the routine chosen. 3 New Report - Print Period Balances Reports on this screen show the balances as at the end of a period. The report identifying the approvals will show approvals as at the month end date of the last period selected. This is because periods are not applied to approvals, only dates. Payments against approvals do show periods so they will be used in the Outstanding calculation. New Report. - Print Statements - Unrealised. This report is based on the statement routine combined with the routine to calculate the unrealised gain.
Added an option on the print Approvals
Statements to select all or outstanding. ------------------------------------------------------------------------------------------------- Dates in Batches, Approvals, Assets and
Direct Input can only be on or before the current date, ------------------------------------------------------------------------------------------------- Print Blank Periodic Statements re-introduced to allow for customers not using the new period statement print.
New Field added to users database to identify
a path unique to each user for their Excel program.
Print Investment Tax Reclaim Form Added an option to select all reclaimed tax transactions or just transactions with outstanding tax to be reclaimed. Year end option Delete Funds option enabled (Use the Balance Brought Forward screen). Messaging system added to identify users logged in and to send an receive messages and to send and received logged messages. Added and Outstanding Value range selection to "Print all Approvals"
Managers Statements. Added a selection to pick out period transactions. The report now displays the manager's name and not the primary managers name. Routine added to I&E code to automatically adjust the Excel file location Assets. Option added to allow the user to use a code beginning with 9999 and then to enter the total value and have the unit value calculated. If a unit value is entered then the calculation of the total value remains the same. The Calculation remains the same for all other rules codes.
I&E Statements Period Balance List.
Income and Expenditure Codes. New Report added to print a statement of individual I&E Codes Income and Expenditure Codes. New Report added to print I&E Codes Notes Details Values and Roundings. Unbalanced Control Transaction splits. Values can now be edited for all account types except for Fund A/c's. Editing is also allowed even if the amounts are in balance, allowing you to transfer amounts from one restriction type to another.
------------------------------------------------------------------------------------------------- Trustees Report 6 allows two type of report to be produced, one with the full text description, the other with fields imported from the general ledger to be identified separately (This report only applies if you are automatically importing data from your general ledger).
Two new reports added to the Investments Market Value report option. Sorted and subtotalled by UK/Non-Uk and FT Code. New Report added to transaction analysis details report allowing each code to be sorted and sub-totalled by restriction type. Automatic Allocation Routines now split the Restricted, Unrestricted and Endowment Values Brought Forward Balance Screen now clears the invalid split values for the fund type you are entering a balance for, ie if a fund is unrestricted then the Restricted and Endowment brought forward values are set to 0.00 ------------------------------------------------------------------------------------------------- Automatic Allocation routines amended to allow you to transfer your own text for the details of each transaction or accept the default text. Asset Revaluation reports amended. Selection and Layout.
"Unbalances Control Transaction Splits" moved to this menu. "Check Batches" added to this
menu.
Option added to the Income and Expenditure Codes Screen to print out notes to the accounts. Option added to year end to allow previous years balances to be retained for SoFA. (Brought forward balances for balance sheet are derived from accounts.) Transactions based on a value, 3 new reports added to allow sorting/subtotalling by Account, or sorted into ascending or descending value order. Allocation of outstanding tax on dividends simplified and additional error trapping added. All report selections screens will now default the Input date selection from the year start date to the current system (today's) date.
Processing added to Batch Input and Direct Input to verify that codes used relate to the Fund / Account Type. I&E (SoFA) codes for Fund Accounts and Balance Sheet Codes to Control Accounts. Field added to Managers Details to identify the location of Excel spreadsheets created from the system for each manager. (Statements)
I&E Statements - Managers Fund Summary - Layout changed ------------------------------------------------------------------------------------------------- Option added to reports menu to identify unbalanced transactions. That is a transaction where the split between the unrestricted, restricted and endowment identified. This takes you into a screen allowing
you to view all unbalanced transactions and identify the split between
the types. Extra processing added to direct input screen to ensure that any manual transaction keyed in must identify the split between the fund types. ------------------------------------------------------------------------------------------------- Posting Rules report changed Movements to be posted Report changed Option added to allow the user to choose whether to restrict approvals to only the managers of the relevant fund. Investments/Assets Screen WARNING - If you use the screen without revaluations then please ensure the posting rules for sales are adjusted to use the Book Value and not Total value where appropriate. Income and Expenditure statements layouts changed to create more white space. Company Details New Field added to allow restrictions of approvals to managers for the related fund only. ------------------------------------------------------------------------------------------------- New field added to Managers Table to allow the identification of the location of all files created using the Intranet Creation Routine Net Dividend field added to Investment / Asset screen.
SoFA Admin Screen to allow manual entry of Brought Forward values to SoFA items. Previous years values transferred to Balance Sheet. Historic Cost Value added to Investments (£ and euro) being the total held value multiplied by the average cost per share. Historic Average Cost Added to Investments I&E Statements, Total Available Value and Net Value for each transaction calculated as part of the report. Receipts Import, Fields for Surname and Forenames and Text Details, fields have been transposed. Investments Dividend Tax Reclaim Form report added.
When a partial sale of an investment is made then a revaluation of all remaining shares is calculated, based on the unit value of the sale. All Funds Total Value fields have been
increased from 12 to 14 allowing numbers from
Added Period and Opening values to the Investments for Market Value, Book etc. Investment Statement Added. Investment Movements. Net Value field added to transactions and shown on movements report. Posting Rule selection added to Investment movements. Market Value for investments updated on all movements (previously only on revaluation). Trustees reports alignment amended and an additional version of report 1 added. Values Report now selects correctly if "equals" and "ignore sign" selected.
Web Site Creation facility to create intranet web site statements for all managers. ------------------------------------------------------------------------------------------------- Income Statement Added. Trustees Reports added Report Groups Codes added to refine selections for Trustees Reports. Field Added to identify the brought forward transfer location when creating the SOFA and Balance Sheet. Fields to split the brought forward into Endowment, Restricted or Unrestricted. Managers Screen - Option added to create web site of statements. Pick Added to Purchase invoices to select by Discount Expiry Date. Check in Purchase invoices to ensure the invoice has not already been entered for a supplier. Pick added to Payment amount. Pick added to Balance in Funds Managers Signature added to Approvals screen. Automatic Approval Numbering Added. Option to allow a check total on Batches added Option to restrict approvals to limit of Fund Balance, Managers Approval limit.
|