Home - All Categories - Solutions by Business Process - Finance - Nominal and Cashbook

Cashbook Bank Reconciliation Improvements

Datafile Software Cashbook Bank Reconciliation Improvements The Bank Reconciliation screen displayed a list of 10/16 transactions per screen and you scrolled up/down the list as you reconciled the transactions against your bank statement but...

Full Mode Financial Summary Definition - Nominal

Datafile Software Full Mode Financial Summary Definition - Nominal A full mode financial summary prints a single ‘page’ (up to 132 lines). The page can be up to 255 characters wide. You can print up to twenty columns of figures ...

Set Non-Posting Status Flag - Nominal

Datafile Software Set Non-Posting Status Flag - Nominal If using a partitioned code structure then the ‘header’ accounts should be flagged for ‘non-posting’ – i.e. no journals are entered for these accounts. When you...

Financial Summaries - Percentage Variance Column

Datafile Software Financial Summaries - Percentage Variance Column Financial Summaries allow the print of variance values between items such as actual values against budgets, this year’s actual values against last year actual values etc...

Payments with Remittance Advice - Cashbook

Datafile Software Payments with Remittance Advice - Cashbook This option allows you enter your payments within the Cashbook and produce a remittance advice (and cheque) as opposed to entering them in the Purchase Ledger. It is only applicable...

VAT Adjustments - VAT on Imported Goods

VAT on Imported Goods When goods are purchased from a country outside the EU then import VAT may be applied. Typically, a separate invoice is supplied from the courier showing the amount of import duty and VAT due. Subject to the normal rules...

Fuel Scale Charge Posting

Fuel Scale Charge Posting If your company is registered for VAT, you can reclaim the VAT element of any expenditure on fuel provided by your company for use with company cars. This usage includes both private and business mileage. In return, HM...

VAT Form 100 - Group VAT Registration

Group VAT Registration The Cashbook VAT Form 100 reports its entries based on Nominal Ledger transactions. In a multi company environment where companies share the same VAT registration number, these need to be consolidated to submit the VAT...

VAT Adjustments - Partial VAT Exemption Scheme

Partial VAT Exemption Scheme (VAT Notice 706) A business is partially exempt if it makes, or intends to make, both taxable and exempt supplies and incurs tax on costs that relate to both. If your business is partially exempt, then you may...

VAT Adjustments - Post-Dated Purchase Invoices

Post-Dated Purchase Invoices The Datafile Purchase Ledger allows posting to the current purchase ledger period and one future period. If you receive a purchase invoice for an earlier period that has now been closed, you can post that transaction...

Receipt and Payment Posting - Cashbook

Datafile Software Receipt and Payment Posting - Cashbook The most frequent use of receipt transactions is for recording the cheques received in any one day. You may be banking a number of cheques, some charge card receipts like American...

Daily VAT Totals on Nominal Update from Sales / Purchase

Datafile Software Daily VAT Totals on Nominal Update from Sales / Purchase Some Datafile users have accounting periods which do not exactly match their VAT months/quarters. For example, the working month may start on the 3rd of a month and end...

Journal Entry - Nominal

Datafile Software Journal Entry - Nominal There are many requirements when you may need to post a journal to the nominal ledger: Posting payroll entries (if you do not already link the Datafile Software payroll to the nominal ledger) Posting...

Cash Book Transactions - Cashbook

Datafile Software Cash Book Transactions - Cashbook The various types of journal include cash receipts and cash payments, transfers between cash accounts, journal entries, and automatic postings. The cashbook program itself allows you to...

Defining Financial Summaries - Nominal

Datafile Software Defining Financial Summaries - Nominal On the Professional,Diamond and Premier product ranges you can design up to 40 financial summaries such as profit and loss statements, balance sheets, funds flow and other management...

Audit Pointers - Nominal

Datafile Software Audit Pointers - Nominal This option checks and resets the relationship between the accounts and transactions file. On selection you are asked whether you want to perform the check for all master records or for individual codes ...

Delete an Account - Cashbook

Datafile Software Delete an Account - Cashbook Selecting the DELETE option allows you to delete an account. You cannot delete an account unless it has a non-zero balance, nor can you delete an account which still has transactions on file. Indeed...

Default Bank Account for Receipts and Payments

Datafile Software Default Bank Account for Receipts and Payments When posting a receipt or a payment the system uses the default bank account as recorded within the Nominal and Cashbook System Profiles which can then be changed as required...

System Profiles - Nominal

Datafile Software System Profiles - Nominal You specify here a number of parameters that are required if you are using the nominal ledger and/or cash book. Some of these parameters are used by other applications, such as the sales and purchase...

DELETE - Delete an Account - Nominal

Datafile Software DELETE - Delete an Account - Nominal You cannot delete an account unless it has a non-zero balance, nor can you delete an account which still has transactions on file. You may have to wait until after all transactions for the...

Column Headings for Financial Summaries Spreadsheet Output

Datafile Software Column Headings for Financial Summaries Spreadsheet Output When you output a ‘full-mode’ financial summary to Excel/OpenOffice the system uses the balance item as the column heading. However, for special balance...

Hyperlinks on Full Mode Financial Summaries

Datafile Software Hyperlinks on Full Mode Financial Summaries Release 6.1 introduced links within screen/spooled reports allowing you to review a report and then access the Ledger Enquiry based on links against the account / stock / order...

Increased Nominal Account Name Size

Datafile Software Increased Nominal Account Name Size The Nominal Account Name item size is by default 25 characters and whilst this could be increased screen limitations in the NAMES functions of the account maintenance restricted the maximum...

Making Tax Digital – VAT Form 100

Datafile 2019 and above Making Tax Digital is a part of the government’s plans to make it easier for individuals and businesses to get their tax right and keep on top of their affairs. Every business now has access to their own...

Financial Summaries

Datafile Software Financial Summaries This new release brings a major improvement in the financial summary design process for ‘full mode’ reports in that you can now control font and size for both data and text items and insert...

VAT Form 100 - Cashbook

Datafile Software VAT Form 100 - Cashbook This option allows the facility to print the details required for the quarterly (monthly) VAT Form 100 that all VAT traders in the UK must send to their VAT offices. The facility can also print an audit...

Post Bank Charges - Cashbook

Datafile Software Post Bank Charges - Cashbook This option gives you a journal entry screen exactly as described already for Journal Entries above. Follow the instructions there.

VAT Form 100 - Process on Period Dates

Datafile Software VAT Form 100 - Process on Period Dates The VAT Form 100 can be configured to work on monthly or quarterly periods and processes based on the calendar – i.e. if monthly processes transactions from 01/01/2008 to 31/01/2008, if...

Select Key Definition - Nominal

Datafile Software Select Key Definition - Nominal Whenever you press against an application database within the nominal ledger the details displayed can be configured to show what you require. This is done via the ‘Select...

Receipt Column Headings - Cashbook

Datafile Software Receipt Column Headings - Cashbook You use this option to define the columns you want for entering cash receipts, and the characteristics of each column. The definition screen is shown below, and the list already shows the...

Reverse Dated Provisionals - Nominal

Datafile Software Reverse Dated Provisionals - Nominal This procedure is similar to the above except that it reverses provisional journals for which you did enter a reversal date for the current period. As with the previous option you are asked...

Nominal Transactions - Nominal

Datafile Software Nominal Transactions - Nominal The various types of journal include a single entry journal with matching debit and credit amounts; multiple debit and credit journals (up to a maximum of 200 in one journal) provided that total...

Journal Cleardown - Nominal

Datafile Software Journal Cleardown - Nominal You can clear transactions from the transactions file whenever you like and you do not have to remove transactions at all (subject to product level file size limits). You are advised to keep all...

Cash Flow Forecast - Cashbook

Datafile Software Cash Flow Forecast - Cashbook Cash flow planning has two distinct flavours: Short-term cash flow, needed by you to make sure you are in funds. This looks forward only a few weeks, you may well revise it daily (at the minimum,...

Trial Balance - Cashbook

Datafile Software Trial Balance - Cashbook A trial balance reports all the cash book accounts, with their current balances listed in the debit or credit column as appropriate, and so gives a complete picture of the current position of the cash...

End of Year Procedure - Nominal

Datafile Software End of Year Procedure - Nominal This procedure opens up a new year for the company. As discussed earlier you may have to do this shortly before the actual year-end for ‘forward postings’ in the sales and purchase...

Trial Balance - Nominal

Datafile Software Trial Balance - Nominal A trial balance reports all the nominal ledger accounts, with their current balances listed in the debit or credit column as appropriate, and so gives a complete picture of the current position of the...

System Status - Nominal

Datafile Software System Status - Nominal This displays a summary of the current status of the nominal ledger. It acts as a useful check on the ledger. COMPANY — displays the identifying code and the name of the company in use FILES ...

Close Period for Posting

Datafile Software Close Period for Posting The Accounting Calendar within Datafile is open for two financial years – the current year and the previous year and whilst the sales, purchase and stock ledgers are set in one period within the year...

Additional Sales / Purchase Account Display Items

Datafile Software Additional Sales / Purchase Account Display Items When posting a receipt or payment the system displays the account name, first two lines of the address and the account balance on entry of the customer / supplier account code...

User Defined Journals - Nominal

Datafile Software User Defined Journals - Nominal Many of the transactions which you need to enter into the nominal ledger are the same from one period to the next, with only perhaps some changes in values. To help you speed up journal entries...

Database Profiles - Nominal

Datafile Software Database Profiles - Nominal Database Profiles are the interface between the program and the databases, they allow the program to read/update the data and interpret the values contained within. The data item profiles for the...

Journals - Nominal

Datafile Software Journals - Nominal Although you almost certainly update your nominal ledger automatically from your sales and purchase ledgers and maybe from other systems such as payroll and fixed assets too, there are many other...

Cashbook - Global Transaction References

Global Transaction References When posting Receipts and Payments within the Cashbook then the system has the option to increment references – historically this has been used for paying in slip references for receipts and cheque numbers or...

System Profiles Screen 2 - Cashbook

Datafile Software System Profiles Screen 2 - Cashbook For each of the sales and purchase ledgers you are asked the following questions: Use Receipt/Payment ref as "Reference"? You enter a journal number against each cash book...

Reconcile Bank Account - Cashbook

Datafile Software Reconcile Bank Account - Cashbook This option allows you to perform the reconciliation procedure.Cash Account Give the cash book account code for this account. The account name is then displayed. You can from the...

End of Year Procedure - Cashbook

Datafile Software End of Year Procedure - Cashbook This procedure opens up a new year for the company. As discussed earlier you may have to do this shortly before the actual year-end for ‘forward postings’ in the sales and purchase...

Multiple Updating - Update From Any Datafile Database File - Nominal

Datafile Software Multiple Updating - Update From Any Datafile Database File - Nominal This option allows you to define how to update from any Datafile database file. You can create some very powerful system links outside the standard ledger and...

Easy Mode Financial Summary Definition - Nominal

Datafile Software Easy Mode Financial Summary Definition - Nominal When you select an ‘easy mode’ financial summary at run-time you are prompted If you reply ‘No’ then you continue to print the summary report. If you...

Record Journal Number on Sales / Purchase Transactions

Datafile Software Record Journal Number on Sales / Purchase Transactions When you update the nominal ledger from the sales/purchase ledger the system creates an ‘audit trail’ report of the import transactions processed and records...

Revalue a Nominal Account - Nominal

Datafile Software Revalue a Nominal Account - Nominal The need to revalue nominal accounts normally comes about only due to a change in the holding rate.Even in this event it may only be certain balance sheet accounts which need to be revalued....

Reverse Journals - Continue to Next Entry

Datafile Software Solutions Reverse Journals - Continue to Next Entry Historically the Nominal Journal Reference was a four-digit number. Whilst we now allow a six-digit reference, many users still use a four-digit value and, as such, have...

Update from Other Ledgers - Nominal

Datafile Software Update from Other Ledgers - Nominal Your nominal ledger system is often linked to other Datafile Software systems such as the sales and purchase ledgers, and payroll. This option enables you to extract details of all the...

Names - Cashbook

Datafile Software Names - Cashbook This is a fast way to enter account codes with the information needed for income and expenditure accounts. You can enter the cash and control accounts using this option too, but you should take the Cash Account...

Cash Book Listings - Cashbook

Datafile Software Cash Book Listings - Cashbook Here you define what items are to print on the specific cash book reports. Each of these reports uses the transactions file, except for the cash statement report which uses the accounts file as...

Transaction / Detail Enquiries - Nominal

Datafile Software Transaction / Detail Enquiries - Nominal This option gives you the ability to configure the display of the transaction enquiries available for each nominal record. On selection of this option you are able to set the authority...

Drill Down Enquiry - Nominal

Datafile Software Drill Down Enquiry - Nominal Particularly useful when using a cost-centre structured nominal code this option gives you a view of the ledger at the highest level and you can then drill-down to the lower levels of the hierarchy...

Year End Procedures - Nominal

Datafile Software Year End Procedures - Nominal The nominal ledger keeps all periods of the year open, so there are no particular actions which need to be taken at the end of each period. For your convenience you can set the default period...

Compact & Audit Database - Nominal

Datafile Software Compact & Audit Database - Nominal The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the nominal account file). New...

Reverse Journals - Nominal

Datafile Software Reverse Journals - Nominal You may want to reverse a journal (other than a provisional journal) at any time. Perhaps a journal you entered is found to be incorrect, or an accrual you entered was over-cautious and you need to...

Recall Standard Text - Cashbook

Datafile Software Recall Standard Text - Cashbook Recall Standard Text allows you to attach a word or phrase to a specific key combination (such as + ). For example you might have a series of standard texts to use for the...

Multiple Updating - Update From Another Nominal - Nominal

Datafile Software Multiple Updating - Update From Another Nominal - Nominal This option assumes that the external nominal transaction file is in exactly the same format as this company’s nominal transactions file, and it also assumes you...

Transaction / Detail Enquiries - Cashbook

Datafile Software Transaction / Detail Enquiries - Cashbook This option gives you the ability to configure the display of the transaction enquiries available for each nominal record. On selection of this option you are able to set the authority...

Display Debit / Credit Totals during Journal Input

Datafile Software Display Debit / Credit Totals during Journal Input During journal entry you input debit / credit values and the system will only allow update of the journal when the totals match. Now, following requests, the system will display...

Reverse Provisionals - Nominal

Datafile Software Reverse Provisionals - Nominal In most cases those provisional journals which you have entered into one period need to be reversed out of the following period. This option provides an automatic way to reverse the journals that...

Enquiries Configuration - Nominal

Datafile Software Enquiries Configuration - Nominal This option allows you to configure the Ledger Enquiry for each of the applications. After selecting the application a list of available options are displayed.

Reports & Analyses - Cashbook

Datafile Software Reports & Analyses - Cashbook These reports are almost exactly the same as the Report Listings & Analyses in the nominal ledger. Even though you may not be using the nominal ledger, you still have the same requirement...

Payment Column Headings - Cashbook

Datafile Software Payment Column Headings - Cashbook Payment columns are defined in exactly the same way as for receipt columns, as shown in the screen below. Notes This example shows a "contra” column defined to allow matching of invoices...

Financial Summaries - Nominal

Datafile Software Financial Summaries - Nominal Financial summaries are the special management reports that show, amongst other things, the profitability or otherwise of the company. You use this part of the nominal ledger to produce such...

Bank Reconciliation

Datafile Software Bank Reconciliation Some additional features have been added to the Bank Reconciliation option to improve this action. Pre-Enter Closing Balance This new option allows you to pre-enter the closing balance the reconciliation...

Include Older Transactions on Audit Trail

Datafile Software Include Older Transactions on Audit Trail When printing an Account Audit Trail within the Nominal Ledger or Cashbook you are able to confirm the period number and the date range of the transactions to display. The date range...

Utilities - Cashbook

Datafile Software Utilities - Cashbook This menu provides options to define and maintain the auto-posting procedures, the payment and receipt templates, and allows you to perform sales and purchase allocations.

Enter New Transactions during Bank Reconciliation

Datafile Software Enter New Transactions during Bank Reconciliation This new feature allows the option to enter new receipts, payments or bank transfers during the bank reconciliation procedure allowing you to enter transactions you may have...

Sales Allocations, Purchase Allocations - Cashbook

Datafile Software Sales Allocations, Purchase Allocations - Cashbook You can use either of these options to allocate invoice, payment and credit note transactions together in the sales ledger and in the purchase ledger respectively. When you...

Unpresented Listing - Cashbook

Datafile Software Unpresented Listing - Cashbook This report gives a bank statement-style report, except that it shows only the transactions which have yet to be allocated. It thus should show the difference between your account balance and the...

System Profiles Screen 1 - Nominal

Datafile Software System Profiles Screen 1 - Nominal Omit Year End for this Nominal You may have configured your system to share the same nominal ledger databases across companies.If you do this then you should only run the year-end in one...

Period/Year End Facilities - Nominal

Datafile Software Period/Year End Facilities - Nominal The two user-defined options here determine what occurs when you clear the nominal transactions file. When Clear Transaction File, Write B/F Balances? You can choose here whether...

Set Current Period - Cashbook

Datafile Software Set Current Period - Cashbook The period number (and year) entered here is used as the default for reports and journals. All periods of the year are open to you, and you can always override the default. However, you should...

Journal Cleardown - Cashbook

Datafile Software Journal Cleardown - Cashbook You can clear transactions from the transactions file whenever you like and you do not have to remove transactions at all (subject to product level file size limits). You are advised to keep all...

Maintain Accounts - Cashbook

Datafile Software Maintain Accounts - Cashbook This option allows you to add, amend, view and delete cash book accounts. If you are already using the nominal ledger, then these options largely duplicate the Maintain Chart of Accounts options...

Commented Items Listing - Cashbook

Datafile Software Commented Items Listing - Cashbook This report gives a bank statement-style report of the transactions which have a comment against them.It gives you a check-list of the outstanding queries between you and the bank. The...

CALC - Recalculate Current Year Budgets - Nominal

Datafile Software CALC – Recalculate Current Year Budgets - Nominal You would use this option at the start of a new year to calculate automatically the new year’s budgets based on either the actual results from the previous year or the...

Cash Book Configuration

Datafile Software Cash Book Configuration Your Datafile Software ledger systems have a wide range of possible facilities, and you can undertake a great amount of structuring so that it suits your particular operation.This section describes how...

Multiple Updating - Nominal

Datafile Software Multiple Updating - Nominal The multiple updating facilities allows you to create up to 40 different updating definitions, from each of which you can update sales and purchase ledgers, payroll, a nominal ledger and one other...

Set Auto Expand Data Files - Cashbook

Datafile Software Set Auto Expand Data Files - Cashbook Datafile reserves a fixed space for database files and you need to expand that space should the file become full. This option allows you to set internal system parameters so that it...

Bank Reconciliation - Cashbook

Datafile Software Bank Reconciliation - Cashbook These procedures are all designed to help you reconcile your bank accounts against the bank or other account statements. The steps you would take to reconcile a statement are: Make sure you have...

Transfers - Cashbook

Datafile Software Transfers - Cashbook These are used specifically to transfer money from one account to another. The transaction process is very similar to receipt and payment transactions, with a header, some details, and a procedure to...

Close Previous Year - Cashbook

Datafile Software Close Previous Year - Cashbook As discussed previously the cash book covers two financial years – a current year and a previous year.You close the previous year once all postings and reports have been completed for that year,...

Nominal Update Configuration - Nominal

Datafile Software Nominal Update Configuration - Nominal Compact and Professional users will be prompted at the end of the system profiles to "Change the Update to Nominal Definition”. Respond Yes or No as required. For further details on this...

Automatic Postings - Cashbook

Datafile Software Automatic Postings - Cashbook This is one of the very useful facilities of the cash book. You can define (via a Utilities menu option) up to 128 standard transactions, such as standing orders and direct debits, which occur...

Journal Listing - Nomimal

Datafile Software Journal Listing - Nominal This reports the journal transaction entry details from your nominal transaction file. In addition to the standard prompts described above for the reporting options, you may also select a range of...

Application Screen Layouts - Cashbook

Datafile Software Application Screen Layouts - Cashbook This option allows access to the ‘Maintain Accounts’ section of the Application User Facilities.Refer to this section above for further details.

Transaction Listing - Cashbook

Datafile Software Transaction Listing - Cashbook This reports the transaction entry details from your cash book transaction file. It is exactly the same as the nominal ledger Journal Listing, for an example view this option in the Nominal Ledger...

Nominal Ledger Configuration

Datafile Software Nominal Ledger Configuration Your Datafile Software ledger systems have a wide range of possible facilities, and you can undertake a great amount of structuring so that it suits your particular operation.This section describes...

Select Key Definition - Cashbook

Datafile Software Select Key Definition - Cashbook Whenever you press against an application database within the cash book the details displayed can be configured to show what you require. This is done via the ‘Select Key...

Provisional Journals - Nominal

Datafile Software Provisional Journals - Nominal This option is used to enter provisional journals and operates in exactly the same manner as described above. The only difference is that the system automatically sets the provisional flag (and...

Maintain Auto Postings - Cashbook

Datafile Software Maintain Auto Postings - Cashbook You can define up to 128 automatic posting transactions. You would use these for bank transactions which you can predict, such as standing orders and direct debits. They can be as frequent as...

Other Journal Options - Nominal

Datafile Software Other Journal Options - Nominal This option gives a sub-menu of further journal procedures including options to reverse journals and to revalue currency accounts.

Transaction Control Numbers - Nominal

Datafile Software Transaction Control Numbers - Nominal This option lets you manually reset certain transaction pointer numbers in the control files. 1) Highest B/F Transaction after Clear Down This pointer holds the highest b/f transaction...

Information Only Accounts

Datafile Software Information Only Accounts When designing a financial summary you often want to include non-financial information such as, value of orders taken this period, value of quotes made, calls made/received, etc. for reporting and...

Memo Facility Configuration - Nominal

Datafile Software Memo Facility Configuration - Nominal The Memo facility allows you to record notes against nominal records. Within the Ledger Enquiry Manager you have the option to define, for all applications, where the memo files are...

Journals - Cashbook

Datafile Software Journals - Cashbook Standard journal entries work in exactly the same way as the Transfers option described above, except that you can reference any nominal/cash book accounts in this transaction. For example, you may have...

Ledger Enquiry Manager - Cashbook

Datafile Software Ledger Enquiry Manager - Cashbook Although sharing the same databases as the Nominal Ledger the enquiry options are independent. The Ledger Enquiry Manager (Diamond and Premier only) allows you configure the display screens...

Audit Pointers - Cashbook

Datafile Software Audit Pointers - Cashbook This option checks and resets the relationship between the accounts and transactions file. On selection you are asked whether you want to perform the check for all master records or for individual...

Close Previous Year - Nominal

Datafile Software Close Previous Year - Nominal As discussed previously the nominal ledger (and cashbook) covers two financial years – a current year and a previous year. You close the previous year once all postings and reports have been...

Set Application Code Formats - Cashbook

Datafile Software Set Application Code Formats - Cashbook This option allows you to set the prime index format for each of the application databases including the nominal account files which are used for both the nominal ledger and the cash...

Ledger Enquiry Manager - Nominal

Datafile Software Ledger Enquiry Manager - Nominal The Ledger Enquiry Manager (Diamond and Premier only) allows you configure the display screens for the Nominal Ledger Enquiry. Enquiries Allowed for this Company Although there are no specific...

Database Audit - Cashbook

Datafile Software Database Audit - Cashbook Use this option to check the internal integrity of any of the nominal/cash book files. If you’re sure that a particular record is in the file but you cannot select it via the indexes then you...

Year End Facilities - Cashbook

Datafile Software Year End Facilities - Cashbook Most users will not have this option on their menu. If you are running a nominal ledger then you use the nominal year-end processes to close years and open new years. If however, you do not have...

Update from Other Systems - Nominal

Datafile Software Update from Other Systems - Nominal The Datafile Software nominal ledger possesses very powerful features for incorporating data from other systems. Most users will want to update from the sales and purchase ledgers and perhaps...

Set Auto Expand Data Files - Nominal

Datafile Software Set Auto Expand Data Files - Nominal Datafile reserves a fixed space for database files and you need to expand that space should the file become full. This option allows you to set internal system parameters so that it...

Transfer Listing - Cashbook

Datafile Software Transfer Listing - Cashbook This reports the cash transfer transactions as a simple audit list.

Additional Options for Bank Reconciliation

Datafile Software Additional Options for Bank Reconciliation This new feature displays additional information from the current transaction record when reconciling the bank account. When marking a transaction as reconciled the key is...

Application Manager - Nominal

Datafile Software Application Manager - Nominal Select the Application Manager (Diamond and Premier only) menu option gives a further sub-set of actions. The options available on this menu are discussed in their own sections later on where...

Set Application Code Formats - Nominal

Datafile Software Set Application Code Formats - Nominal This option allows you to set the prime index format for each of the application databases including the nominal account files. The default format for nominal is 999 – this forces...

Quick Allocation Options

Datafile Software Quick Allocation Options Two new features have been added to the allocations process to speed processing when entering payments.This applies when pre-allocating whilst entering the payment or on allocation immediately after...

Controls and Audit Manager - Nominal

Datafile Software Controls and Audit Manager - Nominal The Controls and Audit Manager contains all the utility routines used to check the integrity of the database files and to undertake various housekeeping actions. The tools supplied allow:...

Trial Balance - Omit Zero Value Accounts

Datafile Software Solutions Trial Balance - Omit Zero Value Accounts When printing the Trial Balance the system reports all nominal accounts subject to selection criteria. Where you have a coded structure you may have a number of accounts...

Set Current Period - Nominal

Datafile Software Set Current Period - Nominal The period number (and year) entered here is used as the default for reports and journals. All periods of the year are open to you, and you can always override the default. However, you should...

Receipt Totals Analysis, Payment Totals Analysis

Datafile Software Receipt Totals Analysis, Payment Totals Analysis These reports serve a similar purpose to the preceding reports, except that they summarise the receipts and payments details into one line each. It is usual to show the individual...

Period/Year-End Facilities - Cashbook

Datafile Software Period/Year-End Facilities - Cashbook There are no user-defined items for these options.

Application Screen Layouts - Nominal

Datafile Software Application Screen Layouts - Nominal This option allows access to the ‘Maintain Accounts’ section of the Application User Facilities.Refer to this section above for further details.

Database Audit - Nominal

Datafile Software Database Audit - Nominal Use this option to check the internal integrity of any of the nominal files. If you’re sure that a particular record is in the file but you cannot select it via the indexes then you might want to...

Reports and Analysis - Cashbook

Datafile Software Reports and Analysis - Cashbook You can print reports whenever you need them for any period in the current, and if still open, the previous year. Selecting the Reports menu gives you a list of available reports. Prompts Used...

Transaction Control Numbers - Cashbook

Datafile Software Transaction Control Numbers - Cashbook This option lets you manually reset certain transaction pointer numbers in the control files. 1) Highest B/F Transaction after Clear Down This pointer holds the highest b/f transaction...

Report Listings & Analyses - Nominal

Datafile Software Report Listings & Analyses - Nominal Here you define what items are to print on the nominal ledger reports. For each report you must define the print style to use and the data items which are to print. See the Nominal...

VAT Form 100 - Online Submission

Payroll users will be familiar with the process where each payroll run an online Full Payment Submission (FPS) is processed to the HMRC. For VAT, however, users have typically recorded the details online via the HMRC website – in Datafile 2018 a...

Expand Data Files - Nominal

Datafile Software Expand Data Files - Nominal If not setting the auto-expand options then this option allows you to manually expand the data files as necessary.

Maintain Receipt Templates, Maintain Payment Templates - Cashbook

Datafile Software Maintain Receipt Templates, Maintain Payment Templates - Cashbook You can define up to twenty transaction templates for both receipt transactions and for payment transactions using these options. Taking either of these options...

Controls and Audit Manager - Cashbook

Datafile Software Controls and Audit Manager - Cashbook The Controls and Audit Manager contains all the utility routines used to check the integrity of the database files and to undertake various housekeeping actions. The tools supplied allow:...

Transactional Optional 1 - Nominal - Database Profiles

Datafile Software Transactional Optional 1 - Nominal - Database Profiles Data Item Type Alternative Notes Reference X (6) ? Often used to hold sales/purchase reference on update, or internal docket number for nominal journals Analysis N T, C Can...

Application Manager - Cashbook

Datafile Software Application Manager - Cashbook Selecting the Application Manager (Diamond and Premier only) menu option gives a further sub-set of actions. The options available on this menu are discussed in their own sections later on where...

Memo Facility Configuration - Cashbook

Datafile Software Memo Facility Configuration - Cashbook The Memo facility allows you to record notes against nominal/cash book records. Within the Ledger Enquiry Manager you have the option to define, for all applications, where the memo...

Bank/Cash Statement - Cashbook

Datafile Software Bank/Cash Statement - Cashbook This report prints out the transaction details for your cash accounts in the same format as you would receive your bank statements.

List of Accounts - Nominal

Datafile Software List of Accounts - Nominal Use this report to give you a complete chart of accounts on your system, together with the markers to show whether profit and loss or balance sheet account, whether to be fully updated (if you are...

Optional Account Items - Nominal - Database Profiles

Datafile Software Optional Account Items - Nominal - Database Profiles Data Item Type Alternative Notes Date set up D E System date written here when new account added Full updating ?-type Overrides consolidated update for this account if set to...

Customer and Supplier Default Bank Accounts

Datafile Software Solutions Customer and Supplier Default Bank Accounts Sales and Purchase Accounts can optionally have a default bank account recorded against them that applies during receipt and payment entry in the posting options within the...

Account Cash Book - Nominal - Database Profiles

Datafile Software Account Cash Book - Nominal - Database Profiles These items apply only to cash accounts, and are needed only by the Cash Book application. Data Item Type Alternative Notes Cash account? ?-type If Y ensures this account is...

Account Enquiry - Cashbook

Datafile Software Account Enquiry - Cashbook This provides an easy way to view an account and its transactions. You are first asked for the account code. You can use the facility to search for an account here in the usual way....

Unpresented Listing for Currency Bank Accounts

Datafile Software Unpresented Listing for Currency Bank Accounts The Nominal Ledger and Cashbook reports primarily report values using the base currency of the system.Selected reports have a secondary reporting option to run the report detailing...

Financial Summaries - Additional Calculation Options

Datafile Software Financial Summaries – Additional Calculation Options The Financial Summaries allowed a calculation option which supported the use of plus and minus options.Changes to Full Mode summaries, using the new designer only, will...

Compact & Audit Database - Cashbook

Datafile Software Compact & Audit Database - Cashbook The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the nominal account file). New...

Defining User Journals - Nominal

Datafile Software Defining User Journals - Nominal If you press the key from the User-Defined Journals menu as described above, then you are put straight into the definition process. This section describes how you define these...

Standard Update – Payroll - Nominal

Datafile Software Standard Update – Payroll - Nominal After entering/confirming the sales and purchase update details the next four screens define how the payroll is to be updated into the nominal. First you are asked if you want to change the...

Account Audit Trail, Account Audit Trail (Currency) - Nominal

Datafile Software Account Audit Trail, Account Audit Trail (Currency) - Nominal The audit trail reports all the transactions which apply to each account printed on the report — it is equivalent to an account statement. It is usual to print...

Receipt Headings, Payment Headings - Cashbook

Datafile Software Receipt Headings, Payment Headings - Cashbook This report lists those accounts which have a non-zero receipt/payment column code against them.These accounts can only be used in receipt/payment transactions which call their...

System Profiles Screen 2 - Nominal

Datafile Software System Profiles Screen 2 - Nominal Financial Summaries Pathname Enter here the pathname for the file that holds the definitions for your financial summaries, such as the Profit & Loss and Balance Sheet statements. The...

Expand Data Files - Cashbook

Datafile Software Expand Data Files - Cashbook If not setting the auto-expand options then this option allows you to manually expand the data files as necessary.

Revalue Nominal Accounts by Currency

Datafile Software Revalue Nominal Accounts by Currency This new option allows the ability to revalue all, or selective, nominal accounts for a particular currency in one process rather than revaluing the accounts individually. On selection of...

Maintain Cash Book Accounts - Cashbook

Datafile Software Maintain Cash Book Accounts - Cashbook Only three of the six choices in the sub-menu below allow you to specify any details. These details are effectively the data items to display when you enter or amend an account in full,...

Account Maintenance Improvements

Datafile Software Account Maintenance Improvements This release brings the improvements to Nominal / Cashbook Account maintenance options that were introduced in earlier releases for the Sales/Purchase Account maintenance screens amongst others....

Warn if Sales/Purchase Account On-Stop

Datafile Software Warn if Sales/Purchase Account On-Stop This release introduces a much requested feature to warn when receipts are posted against a sales account that is marked as ‘on-stop’. Selecting the OK button or...

Cash Account - Cashbook

Datafile Software Cash Account - Cashbook You use this option to add or amend cash accounts, together with their individual characteristics.You can use it for non-cash accounts too. You are prompted at the bottom of the screen to enter an...

Enquiries Configuration - Cashbook

Datafile Software Enquiries Configuration - Cashbook This option allows you to configure the Ledger Enquiry for each of the applications. After selecting the application a list of available options are displayed.

Report Account Status - Nominal

Datafile Software Report Account Status - Nominal The account status report is usually used to provide an overview of the current period and year-to-date balances on nominal ledger accounts.

Maintain Accounts - Nominal

Datafile Software Maintain Accounts - Nominal You use this part of the program to add, amend, view and delete nominal ledger accounts. You also use it to enter the values for budget and comparative items for periods and year, if these options...

Maintain Chart of Accounts - Nominal

Datafile Software Maintain Chart of Accounts - Nominal Only five of the seven choices on the sub-menu on the right allow you to specify any details. The details are effectively the data items to display when you enter or amend an account in full...

Application User Facilities - Nominal

Datafile Software Application User Facilities - Nominal The Application User Facilities allow configuration of the individual Nominal Ledger options – this facility is only available for Diamond and Premier users.

Account Mandatory - Nominal - Database Profiles

Datafile Software Account Mandatory - Nominal - Database Profiles Data Item Type Alternative Notes Account code X (10) Can be X (16) on Premier systems. Account name X (25) Up to 28 characters are displayed in all circumstances. Longer than 28...

Bank Reconciliation - Cashbook - Application User Facilities

Datafile Software Bank Reconciliation - Cashbook - Application User Facilities Of the bank reconciliation choices shown here, only the items without brackets have options you can define.Most choices are reports, and you have the same facilities...

System Profiles Screen 1 - Cashbook

Datafile Software System Profiles Screen 1 - Cashbook Cashbook Installed? If you have purchased the cash book module, then set this option if the cash book is to be used for this present company. Omit Nominal Ledger for this company?...

Revalue All Nominal Accounts - Nominal

Datafile Software Revalue All Nominal Accounts - Nominal This option operates as above but allows the ability to revalue all, or selective, nominal accounts for a particular currency in one process rather than revaluing the accounts individually...

Account Enquiry - Nominal - Application User Facilities

Datafile Software Account Enquiry - Nominal - Application User Facilities This feature allows you quickly to view a nominal account on the screen, including a list of transactions for the account. You can configure up to ten items to display in...

Reports and Analysis - Nominal

Datafile Software Reports and Analysis - Nominal You can print reports whenever you need them for any period in the current, and if still open, the previous year. Selecting the Reports menu gives you a list of available reports. Prompts Used...

Security and User Manager - Nominal

Datafile Software Security and User Manager - Nominal The Security and User Manager, available on Professional upwards, allows you to set authority levels and passwords on specific application options and to define any user authority overrides...

System Profiles Screen 3 - Cashbook

Datafile Software System Profiles Screen 3 - Cashbook Template for Cash Postings File You can predefine up to 40 cashbook posting journals, to simplify entry of common transactions. Define here the pathname of the definition file which is to...

System Status - Cashbook - Application User Facilities

Datafile Software System Status - Cashbook - Application User Facilities There are no user-defined options here, and it is included only for the sake of completeness. It lists the items which are displayed when you choose this option from the...

Account Currency ? 1 - Nominal - Database Profiles

Datafile Software Account Currency ? 1 - Nominal - Database Profiles You should define all the fields in the following three currency screens. Data Item Type Alternative Notes Currency Code X (3) Three-character currency code Current Year Start ...

Account Audit Trail, Account Audit Trail (Currency) - Cashbook

Datafile Software Account Audit Trail, Account Audit Trail (Currency) - Cashbook The audit trail reports all the transactions which apply to each account printed on the report — it is equivalent to an account statement. It is usual to...

Edit System Status Display - Nominal

Datafile Software Edit System Status Display - Nominal Each application has a ‘System Status’ option that summarises the key facts about it, such as files, their sizes, how full they are, the current period number and period dates...

Account Enquiry - Nominal

Datafile Software Account Enquiry - Nominal This provides an easy way to view a nominal account and its transactions. You are first asked for the account code. You can use the facility to search for an account here in the...

Security and User Manager - Cashbook

Datafile Software Security and User Manager - Cashbook The Security and User Manager, available on Professional upwards, allows you to set authority levels and passwords on specific application options and to define any user authority...

Application User Facilities - Cashbook

Datafile Software Application User Facilities - Cashbook The Application User Facilities allow configuration of the individual cash book options – this facility is only available for Diamond and Premier users.

Account Status Report - Cashbook

Datafile Software Account Status Report - Cashbook The account status report is usually used to provide an overview of the current period and year-to-date balances on cash book accounts. You can choose a selective range of account codes for this...

Transaction Currency - Nominal - Database Profiles

Datafile Software Transaction Currency - Nominal - Database Profiles Data Item Type Alternative Notes Currency Code X (3) Three-digit currency code Currency Rate M The exchange rate used for the transaction Currency Amt L K ? Currency C/Net...

Multiple Updating – Payroll Update - Nominal

Datafile Software Multiple Updating – Payroll Update - Nominal This process is exactly the same in every respect as was defined for the payroll in the standard update definition described above.

Transaction Optional 2 - Nominal - Database Profiles

Datafile Software Transaction Optional 2 - Nominal - Database Profiles Data Item Type Alternative Notes Was provisional ?-type This is set to Y if this was a provisional transaction now reversed Text-1 X (30) These three fields are used to store...

List of Accounts - Cashbook

Datafile Software List of Accounts - Cashbook Use this report to give you a list of all cash book accounts on your system, together with the markers to show whether profit and loss or balance sheet account, whether to be fully updated (if you...

Bank Statement Report, Bank Statement Report (FC) - Cashbook

Datafile Software Bank Statement Report, Bank Statement Report (FC) - Cashbook This allows you to print a report very much like the Cash/Bank Statement report under Cash Book Reports above. You would probably include the reconciliation flag and...

Financial Summaries - Nominal - Application User Facilities

Datafile Software Financial Summaries - Nominal - Application User Facilities These are specified from within the nominal ledger itself, and there are no extra user-definable facilities here. If you choose this option you are warned this.

Current Actuals, Previous Actuals, Prev –1 Actuals - Nominal - Database Profiles

Datafile Software Current Actuals, Previous Actuals, Prev –1 Actuals - Nominal - Database Profiles For each of these headings the following values are required: Data Item Type Alternative Notes Start Year Balance L K The actual start-of...

Auto-Run Updates from Another DFD

Datafile 2019 and above The Nominal Ledger allows for the option to create journals from a separate Datafile database – this has been used for the creation of stock valuation and goods received but not invoiced journals amongst others. ...

Mandatory Transaction Items - Nominal - Database Profiles

Datafile Software Mandatory Transaction Items - Nominal - Database Profiles Data Item Type Alternative Notes Journal Number N Y (6) The journal number appears on every transaction of a multiple transaction entry, thus allowing journals to be...

System Profiles - Cashbook

Datafile Software System Profiles - Cashbook You specify here a number of parameters that are required if you are using the cash book.

Account Enquiry - Cashbook - Application User Facilities

Datafile Software Account Enquiry - Cashbook - Application User Facilities This feature allows you quickly to view a cash book account on the screen, including a list of transactions for the account. You can configure up to ten items to display...

System Status - Cashbook

Datafile Software System Status - Cashbook This displays a summary of the current status of the nominal ledger. It acts as a useful check on the ledger. COMPANY — displays the identifying code and the name of the company in use FILES ...

Database Profiles - Cashbook

Datafile Software Database Profiles - Cashbook Database Profiles are the interface between the program and the databases, allow the program to read/update the data and interpret the values contained within. The data item profiles for the...

View an Account - Cashbook

Datafile Software View an Account - Cashbook Selecting the VIEW option displays account details to the screen for you to review. Up to 28 items in two columns of 14 items can be displayed. Note — Datafile Diamond and Premier only In...

Comparatives Report - Nominal

Datafile Software Comparatives Report - Nominal The comparatives report compares your current period and year-to-date account balances against the comparative balances from last year.

Receipt Listing, Payment Listing - Cashbook

Datafile Software Receipt Listing, Payment Listing - Cashbook These reports are used to print the complete details of receipt and payment transactions. Usually they list the receipt or payment details on the left-hand side of the report, with...

Receipt and Payment Entry - Option

Datafile Software Receipt and Payment Entry - Option When posting receipts or payments, you enter the total amount of the posting at the top of the screen and then enter the details that make up the posting. Now when entering the...

Budget Report - Nominal

Datafile Software Budget Report - Nominal The budget report compares your current period and year-to-date account balances against budget.

Edit System Status Display - Cashbook

Datafile Software Edit System Status Display - Cashbook Each application has a ‘System Status’ option that summarises the key facts about it, such as files, their sizes, how full they are, the current period number and period dates...

NAMES – New/Amend Account Names - Nominal

Datafile Software NAMES – New/Amend Account Names - Nominal This is a fast way to enter account codes. Other than the account code and name the only parameter, on a non-currency system, you can change is the P/B indicator. However, most other...

Current Budgets, Previous Budgets - Nominal - Database Profiles

Datafile Software Current Budgets, Previous Budgets - Nominal - Database Profiles For each of these headings a set of value fields must be defined: Data Item Type Alternative Notes Budget 1?13 K L Up to 13 fields (depending on the number of...

Financial Summaries - Accumulated Information Account Values

Datafile Software Financial Summaries - Accumulated Information Account Values Introduced in Release 6.2 ‘Information Only’ accounts within the Nominal Ledger allowed you to record non-financial values in selected nominal accounts...

System Profiles Screen 3 - Nominal

Datafile Software System Profiles Screen 3 - Nominal Budget Factors The nominal ledger has powerful facilities for entering and maintaining budget figures to compare against actual values. One of these is the ability to enter an annual budget...

System Status - Nominal - Application User Facilities

Datafile Software System Status - Nominal - Application User Facilities This screen lists the items which are displayed when you choose this option from the nominal ledger and also asks the following: Maintain Separate Journal...

Account Currency ? 2 - Nominal - Database Profiles

Datafile Software Account Currency ? 2 - Nominal - Database Profiles Data Item Type Alternative Note Date Last Revalued D E Prev. Year Start L K Currency value, mirrors base value above Prev. Actual 1?13 L K Currency values, mirror base...

Account Currency - 3 - Nominal - Database Profiles

Datafile Software Account Currency - 3 - Nominal - Database Profiles Data Item Type Alternative Notes Prev. Year ? 1 Start L K Currency value, mirrors base value above Prev. Year ? 1 Actuals L K Currency values, mirror base values above Prev....

MASTER – Maintain Header Accounts - Nominal

Datafile Software MASTER – Maintain Header Accounts - Nominal Only applicable for Diamond and Premier version and, then only if configured to use the ‘auto-create’ sub-accounts option. This uses the same screen as the FULL mode...

Nominal Accounts File – Item Screen Design - Nominal

Datafile Software Nominal Accounts File – Item Screen Design - Nominal If Diamond (or Premier and you don’t wish to use the full screen design) then this option allows you to quickly configure the display of up to 32 items from the...

FULL – Maintain Accounts in Full - Nominal

Datafile Software FULL – Maintain Accounts in Full - Nominal Use this option to add or amend nominal ledger accounts, together with their individual characteristics. First, an account code is prompted for at the bottom of the screen. You may...

Receipt Posting – Advanced Search Options for Sales A/C`s

Datafile Software Receipt Posting – Advanced Search Options for Sales A/C’s When posting receipts you may find that your customer has paid, for example, by BACS and the name shown on your statement does not match that of the account name...

Standard Update – Sales and Purchase Ledgers - Nominal

Datafile Software Standard Update – Sales and Purchase Ledgers - Nominal In this part of the program you define the parameters needed to update from the sales and purchase ledgers, and following this the update from the payroll for this...

Multiple Updating – Update from Sales and Purchase Ledger - Nominal

Datafile Software Multiple Updating – Update from Sales and Purchase Ledger - Nominal The definition process is similar to that discussed earlier with regards to the standard updates but a few more options are allowed. Note The sales and...

Bank Reconciliation – Default Date for New Transactions

Datafile Software Bank Reconciliation – Default Date for New Transactions The bank reconciliation process allows for the generation of new transactions, via the key, for any postings you may find have been missed when reconciling....

YEAR-TOTALS – Enter Comparative Year Totals - Nominal

Datafile Software YEAR-TOTALS – Enter Comparative Year Totals - Nominal This option lets you change the comparative year total for individual accounts. If the nominal ledger is still open for the previous year then you are warned Reply No. If...

Postponed VAT Accounting

From 1st January 2021, if your business is registered for VAT in the UK you will be able to account for import VAT on your VAT return for goods you import into: Great Britain (England, Scotland, and Wales) from anywhere outside the UK Northern...

Nom/CB Accounts File – Full Screen Design (Premier only) - Cashbook

Datafile Software Nom/CB Accounts File – Full Screen Design (Premier only) - Cashbook In Premier systems you have the option to create two user-defined screens in which to display details from the nominal accounts file.On selection of this...

Nominal Accounts File – Full Screen Design (Premier only) - Nominal

Datafile Software Nominal Accounts File – Full Screen Design (Premier only) - Nominal In Premier systems you have the option to create two user-defined screens in which to display details from the nominal accounts file.On selection of this...

Reports – Today`s Receipts and Payments

Datafile Software Reports – Today’s Receipts and Payments This option, available for the Premier system only, allows you to configure a menu option to run your receipt and payment listings and just include today’s transactions –...

PERIODS – Comparative Input for Periods - Nominal

Datafile Software PERIODS – Comparative Input for Periods - Nominal This option lets you change both the comparative year total and the period values for individual accounts.Period totals must add up to the full year total before the account...

BUDGETS – Budgets Proposed - Nominal

Datafile Software BUDGETS – Budgets Proposed - Nominal You can set up budget figures for each period of the year for some or all accounts. These are maintained using the options on this sub-menu. There are a number of ways to create and update...

Multiple Updating – General Details / Which Systems Allowed - Nominal

Datafile Software Multiple Updating – General Details / Which Systems Allowed - Nominal A number of general questions are prompted Which printer control for update commentary? Whenever you update from any file into the nominal ledger...

COMPARATIVES – Enter Comparative Figures - Nominal

Datafile Software COMPARATIVES – Enter Comparative Figures - Nominal As well as printing financial summaries which compare the current year against the budgets that you have set, you can also compare the current year against last year —...

Multiple Updating – Input from CSV File - Nominal

Datafile Software Multiple Updating – Input from CSV File - Nominal The definition for the update from CSV is largely the same as that from an external database except that the data items you specify are the entries in the CSV file – i.e. ...

CASH – Maintain Bank Accounts - Nominal

Datafile Software CASH – Maintain Bank Accounts - Nominal If the cash book application is in use then this option is available in the nominal menu to allow access to the cash book account maintenance screen. As the nominal and cashbook share...

Nom/CB Accounts File – Item Screen Design - Cashbook

Datafile Software Nom/CB Accounts File – Item Screen Design - Cashbook If Diamond (or Premier and you don’t wish to use the full screen design) then this option allows you to quickly configure the display of up to 32 items from the...

PERIOD – Budget Input for Periods - Nominal

Datafile Software PERIOD – Budget Input for Periods - Nominal Use this option to change the individual period budgets. Although you must give the annual budget figure for an account at the start, it is only when the period budgets add up to...

PREV-YR-TOT – Previous Year-1 Comparative Totals, PREV-YR-PER – Previous Year-1 Period Comparatives - Nominal

Datafile Software PREV-YR-TOT – Previous Year-1 Comparative Totals, PREV-YR-PER – Previous Year-1 Period Comparatives - Nominal These two options are used to change the annual total and period figures for the year before last year.The only...

FACTOR – Factor Period Budgets - Nominal

Datafile Software FACTOR – Factor Period Budgets - Nominal This option is similar to the previous option except that it allows you the option to specify a budget factor table number (1 to 5) to use to create the period budgets for any account....

PREV-YR-TOT – Previous Year Budget Totals - Nominal

Datafile Software PREV-YR-TOT – Previous Year Budget Totals - Nominal It would be rare for you to want to change last year’s budgets, but this allows you to do so. The option is similar to Enter Current Year Budget Totals described above...

ENTER – Enter Current Budget Year Totals - Nominal

Datafile Software ENTER – Enter Current Budget Year Totals - Nominal This option lets you specify the annual budget total for individual accounts. As with the previous option, you can ask that the period budgets are reset at the same time...

Financial Summaries – Account Selection Display

Datafile Software Financial Summaries – Account Selection Display Two options within the Financial Summaries allow for the restriction of accounts processed – the wildcard selection and structure selection facilities. Both of these options...

Reports – Year End Reports

Datafile Software Reports – Year End Reports This option, similar to the above, allows you to configure a menu option to run your reports and include transactions for the entire year. To do this you call the report option with the parameter...

VIEW – View an Account - Nominal

Datafile Software VIEW – View an Account - Nominal This displays account details to the screen for you to look at. Up to 28 items in two columns of 14 items can be displayed. Notes In the Datafile Diamond and Premier systems you can...

PREV-YR-PER – Previous Year Period Budgets

Datafile Software PREV-YR-PER – Previous Year Period Budgets This option is similar to Budget Input for Periods described above except that it is used to change the previous year’s total and period budgets. The right-hand side of the...

Automatic Bank Reconciliation - Automatically Accept Unique Suggested Matches

The reconciliation matching process has three levels of matching. Auto Reconcile – if the transaction date, description, and amount match between the downloaded bank statement and a Datafile bank transaction then the transactions are automatically...

Allow Automatic Reversal of Provisional Journals

When you post a provisional journal, the system can prompt for a date for the transaction to be reversed.An option to reverse the dated provisional journals is available within the Nominal Ledger ‘Other Journal’ options. This new feature...

Additional Lookup Databases for Account Maintenance

The Nominal account maintenance screen within Nominal Ledger and Cashbook allowed the facility of one lookup database, this has now been increased to three lookup databases. Installation Application User Facilities New parameters have been added to...

Automatic Bank Reconciliation - Display Totals When Tag Multiple Entries

As part of the bank reconciliation process where you may have one payment entry on the bank statement that matches multiple entries on the Datafile bank account you have the option to tag multiple entries to match – if the totals on both sides...

Automatic Bank Reconciliation - View Bank Journal

When listing the Datafile bank entries the system displays details from the ‘bank’ transaction. Where a receipt or payment covers multiple analysis transactions it can be useful to view the full journal. Available automatically on...

Automatic Bank Reconciliation - Sorting Transaction Display

When displaying the Statement and Datafile entries for matching the system displays the transactions in date order. Where users have many entries that cannot be matched using the automatic and suggested matching options it can be difficult to find...

Alternate ‘Reference` Label for Receipt / Payment Entry

When posting receipts within the cashbook the system prompts for the ‘Pay In Ref’ – i.e. the slip number for the deposit slip the cheques/cash to be paid into the bank under.Similarly, when posting payments the system prompts for the ...

VAT Form 100 – Extra Items on Transaction Audit Trail

When printing the VAT Form 100 the report is made up of two sections. The first section shows the box 1 to 9 total figures, the second section shows an audit trail of the transactions that make up the VAT Summary. This new feature allows you to...

Real Time Updates – VAT Summary Posting Copy Items

The system configuration options for Real-Time Updates to the Nominal Ledger allows for copy items to be defined from the sales/purchase transaction to the nominal transaction.These copy items are actioned for each analysis line but were not copied...

Nominal Ledger Enquiry - View Source Document

When viewing nominal transactions then, if transactions are updated in detail, the system can display a SL/PL Trans option that displays the source transaction on the sales / purchase ledger enquiry that is the source of that update. This new option...