Arrow – Integrated Financial Software

Arrow System Features:
The following features are consistent throughout the software:

• Message handling on masterfile records, such as debtors, creditors and employees.
• Fast tracking to menu options.
• All module enquiry screens have the ability to drilldown and show transaction details, eg when doing a debtor’s enquiry on an invoice, the line details of that invoice can optionally be displayed.
• System Auditor – the system auditor has been designed to detect integrity of the data, and attempt to correct any inconsistencies.
• Consistency in menu layout between modules, incorporating ‘drop down boxes" and three dimensional field appearance.
• Ability to search by a combination of characters, eg all stock items with "wide" in their stock description.
• Screen defaults can be entered for all data entry screens including report sorting criteria by establishing screen defaults, fields not used can be bypassed or a default value can be entered, thereby greatly decreasing time taken when entering records into Arrow.
• Macro processing gives you the ability to set up a job stream.
• Text retrieval provides the facility to search/find a specific piece of text.
• Printer redirection is the ability to set up different output devices for each form print (eg invoice, cheques) and an output device for the printing of standard reports.
• Executive summary report. This report provides management statistics on the overall status of a particular module. Reporting on the total balance, movement since last time the report was run, and period to date and year to date figures.
• Ability to print transaction list reports for past periods by date range.
• Ability to process ‘future’ dated transactions.
• Print preview facility available to screen.

General Ledger Module:
The general ledger is an integral part of the system but can also be used stand-alone if required. Although the update to general ledger is automated, the operator controls the timing of the update. This provides complete control over the integrity of the data being updated.

The general ledger has been designed to include a report writer. This allows the operator enormous flexibility in the way results can be reported.

How the general ledger module helps:

• The general ledger is important in that it beings together all the subsidiary ledgers, and ensures that the system is in balance.
• Provides the profit and loss statement of the company, together with an analysis of the company’s assets and liabilities in the form of a balance sheet.
• Provides comparison with the budget figures.
• Highlights differences to budget for revenue and expenditure accounts, so further analysis can be done.
• Report writer ensures flexible management reporting.

Cashbook Module:
The Arrow accounting modules have been designed to ensure ease of use, but with powerful features and functionality. The cashbook in particular has designed into it strong cash management features which are not only desirable, but also essential in today’s business environment.

The cashbook has been designed to minimise the data entry requirements, therefore all receipts and payments will automatically update the appropriate debtor and creditor accounts. Due to the design of the cashbook, bank reconciliations are virtually automatic.

How the cashbook module helps:

• Keeps a running balance of your cash position, so you are fully informed and in control.
• Easy understanding of your bank statement, the system provides quick and easy bank reconciliations showing clearly the company cashbook balance, the bank statement balance and the reconciling unpresented receipts, payments and charges.
• The system provides immediate and accurate debtor and creditor trading balances, by automatically updating receipts and payments.
• Cashflow analysis, showing receipts and payments breakdown.
• Automatic periodical payments help to ensure that an accurate cash balance is maintained to ensure proper management of the company.
• Automatic bank deposit listing, for accurate cash depositing to the bank.

Debtors Module:

The debtors module has been designed to provide the operator with numerous time saving features, together with the ease of use, which is a feature found throughout the Arrow Accounting System.

How the debtors module helps:

• Provides immediate generation of invoices, thereby ensuring as early as possible debt collection.
• Allows you to keep effective credit control, by warning if a customer is over their credit terms/limit.
• Provides summary and detailed trial balances, so you can monitor the amount of your customer debt.
• Quick and efficient on-screen inquiry, allowing you to provide excellent customer service.
• Helps plan future direction by analysing sales by customer type and sales code.
• Allows you to generate standard invoicing for groups of customers, thereby reducing the amount of time required to produce them.
• Allows you to enter and view current and future period invoices.
• Calculates sales commission.

Sales Order Module:
The sales order module is integrated to the other modules in the Arrow Accounting System. The system allows you to control your complete order cycle from entering quotes and converting these into sales orders, which in turn can be converted into debtors invoices.

How the sales order module helps:

• Keep details of orders received through to completion, thereby providing immediate status on all orders.
• Enquiry can be made by stock code or customer code, allowing speedy response to customer queries.
• Quotations can be held by the system, so quick and efficient sales orders can be generated.
• Sales invoices can be generated from orders and the debtors’ module will be automatically updated, thereby saving time and reducing keystroke error.
• Orders will automatically allocate stock or backorder, thereby keeping the system constantly up to date.
• Customer service is further enhanced with the ability to view past prices at the time of taking the order.
• The ability to enter future orders ensures that all orders are entered as they are received. This ensures no orders are misplaced.
• Ability to handle standing orders
• Ability to enter individual delivery dates on stock items ordered.

Stock Module:
The stock module provides accurate stock control for the organisation. The module can be run stand alone or integrated to the other modules in the system. Due to the integration of the modules, the full cycle of stock movement can be monitored from the initial purchase of the goods to the eventual sale.

How the stock module helps:

• Monitors the stock value being held by the company.
• Provides a stock reorder report to assist in inventory management.
• Monitors stock movements to ensure that good stock control is maintained.
• Prepares system for stocktake and generates stocktake reports.
• To assist in administering price increases and decreases the system allows for bulk price update.
• Generates a stock on order report, which provides you with analysis of committed cash requirements for stock.

Bill of Materials Module:
The Arrow bill of materials module provides the tool through which raw material stock levels are optimised by effective material requirement planning and stock control.

The bill of materials module details the materials required to manufacture a product. The bill of materials module links with stock, sales orders, purchase orders and job costing,

How the bill of materials module helps:

• Ensures bill of material costs, and actual raw material costs are consistent by providing a bill recosting facility.
• Helps in production planning and material resource planning, eg printing production orders by required date.
• Ensures accurate costing for each production order by entering costing for each production order by entering any variances, or substitutions that occur after production, eg breakages and waste.
• By integrating to sales orders, stock and job costing, minimises double keying of production orders.
• Saves time when establishing similar bills providing a copying facility.

Creditors Module:
The creditors module has been designed to minimise the keystrokes required by the operator. Together with the default facility this allows for maximum efficiency on data input.

It is important to be able to easily reconcile your creditor accounts, Arrow has open item accounts for creditors as well as for the debtors module. This will allow you to keep control of each invoice received, and paid.

How the creditors module helps:

• Payments will automatically adjust the creditors account, so an accurate outstanding creditor balance is always known.
• Provides summary and detailed trial balances, so you can monitor the age of your suppliers’ debt, allowing you to manage it.
• Allows for automatic payments by the due date, thereby ensuring that any prompt payment discounts are taken.
• Helps analyse creditors by creditor and supplier types, allowing you to review who your important suppliers are.
• Automatic cheque generation, to ensure accurate balances are printed onto the cheques.
• Generates automatically a prescribed payments deduction listing.
• Helps with cash planning, allowing you to print a forward payments report, based on due date on creditors invoices.

Purchase Order Module:
Integrated to the creditors, stock, sales order, job costing and bill of materials modules, purchase orders allows efficient entry of and control over orders placed on suppliers.

Integration to the sales order system facilitates automatic allocation of stock to customer backorders and, when used in conjunction with the stock reorder report, ensures timely and effective stock reordering.

How the purchase order module helps:

• Store details of orders placed on suppliers, through to receipt of stock, to entry of suppliers invoice, thereby providing immediate status of all orders.
• Variances between quoted and actual prices and quantities are highlighted at time of stock receipt and invoice entry.
• On-screen enquiry facility allows speedy retrieval of order status.
• Automatic update to sales order backorders allows quick fulfilment of customer orders thereby enhancing service.
• Facility to view past costs at time of purchase order entry enhances the ability to negotiate with suppliers.
• Allows stock to be kept to a minimum allowing for quick stock turnover.

Fixed Assets Module:
The fixed assets module easily maintains accurate and timely balances on assets calculating both book and tax values. Providing complete movement and history of assets including depreciation calculations, revaluations, disposals and asset transfers.

The fixed assets module integrates to all of the following Arrow modules: creditors, job costing, purchase orders and general ledger.

How the fixed assets module helps you:

• Provides the ability to easily calculate depreciation on assets.
• Maintains accurate and timely balances on assets including book and tax values.
• Provides complete history on movement of assets including, revaluation, disposals and asset transfers.
• Seamless integration between modules, no double entry of transactions when purchasing assets, details integrate via purchase orders or creditors.

Payroll Module:
The Arrow Accounting System has been designed to ensure ease of use, together with powerful features and functionality. This is particularly true of the payroll module.

The payroll module allows the operator to set up an individual pay in the form required. This provides for enormous flexibility in the way the payroll is prepared.

It can be run stand alone or integrated to the cashbook, general ledger and job costing modules. This allows for powerful integration to the rest of the Arrow system.

How the payroll module helps:

• Arrow allows you to create and maintain your pay items and leave entitlements in line with your award regulations.
• You maintain the tax scales, so you can respond immediately to any tax changes.
• Arrow reduces the time it takes to maintain your payroll by automating all of your normal time consuming and repetitive tasks. Standard pays that rarely change can be automatically produced with a few keystrokes.
• Mistakes can easily be corrected, by reversing and re-running the required payroll.
• Pay slips, cheques and coinage analysis reports can be produced easily.
• Arrow will automatically accrue and update your employees’ leave entitlements.
• Arrow automatically calculates your gross, tax and net payroll values decreasing the risk of error.

Job and Time Costing Module:
The job/time costing module is integrated to the other Arrow modules. It has the flexibility of allowing you to use the module for job costing, time costing or both.

How the job/time cost module helps:

• Monitors actual cost against estimated cost and calculates variance and percentage variances.
• Extends staff time sheets and reports on staff efficiency.
• Produces quotations for customers automatically from estimates.
• Prescribed payments are automatically calculated based on an overriding percentage or a certified percentage provided by the taxation department.
• Allows recosting of estimates by individual groupings, ie creditors, stock, activities or for all estimated items.
• Allows sub jobs to be consolidated into parent jobs, with no limit on the number of tiers.
• Links activities to employees with varying charge out rates based on the employee and each activity.
• Different charge out rates can be used for the same job depending upon which employee is involved.
• User defined job reports can be produced using the report writer facility.
• Creditor invoices can be entered and will automatically update the creditors module.
• When generating job invoices, debtor balance in the debtors module is automatically updated.

Security Menu Option:
The security option has been designed to restrict and control access to menu options, relating to an individual user and their security level. When a user logs into Arrow, the menu displayed is customised according to each individual.

Security Menu features include:

• The security option provides the mechanism to restrict and control access to users when logging into Arrow.
• The design is such that security levels from 0-9, zero being the lowest, 9 the highest, are allocated to selected modules and menu options or all modules and menu options depending on the requirements of each individual company.
• A user name is then created for each person requiring access into Arrow, this user name can optionally have a password. This user is then allocated the relevant security level of 0-9.
• When that user has logged into Arrow they will only see on their menu those options or modules that have a security level equal or less than their user name security level.
• Hence, the menu is customised based on the user’s security level.

Multi-Company Option:
In environments where there is more than one company operating, the multi-company option has been developed to assist and streamline the creation and optional consolidation of these companies.

Multi-company features include:

• The multi-company option allows for more than 100 companies to be created, each company operates independently.
• When creating new companies it is possible to copy the chart of accounts and financial reports from an existing company.
• This multi-company option allows you to optionally consolidate general ledger balances from nominated companies. This can be done for all companies for the consolidation process.
• In situations where you do not want the total balance of general ledger accounts being posted during the consolidation it is possible to nominate a percentage to include, eg 60% of the account balances for a specific company will be posted during the consolidated process.
• To limit the access to the creation of new companies and the consolidation procedure both are password protected.
• It is always possible to identify within the consolidation company the originating company balances.

Foreign Currency Option:
The foreign currency option is designed for Australian businesses, which either import and/or export products to and from overseas countries.

Foreign currency option features include:

• Purchase orders can be entered and printed in foreign currencies.
• Purchase order receipts can be entered and confirmed in foreign currency.
• Creditors trial balance can optionally be printed in $Aus or foreign currencies.
• Using the "drill down" feature will allow the creditor enquiry screen to view the rate of exchange at time of processing and also the foreign currency value of the transaction.
• Sales orders are entered in $Aus and invoices will be printed in foreign currency.
• Debtors trial balance can be printed in either foreign currency or $Aus.
• Foreign currency exchange gains or losses can be realised and recorded when processing overseas customer receipts or supplier payments.

Special Pricing:
The special pricing option provides the ability to set up and maintain special prices for stock and customer. These special prices can be in the form of a special price, discount percentage, discount value, mark-up percentage or price reduction. These special prices can be set optionally including quantity breaks and date ranges.

Special pricing features include:

• Any of the above special prices can be based on selling pricing 1, 2 or 3, or on the average, standard or last cost or a nominated value.
• Special prices can be entered for quantity breaks. Up to 10 quantity breaks van be set for each special price.
• A date range can also be entered for each special price, and these can optionally be purged/deleted globally when required.
• When printing the stock price list, special prices can optionally be included in this report.
• To maintain special prices once entered, it is possible to bulk price update these, either increase or decreases by percentage or dollar amount.

Multi-Location Stock Option:
The multi-location stock option has been incorporated to allow flexibility in stock control.

Multi-location stock features include:

• Provides the ability to have multiple stock locations.
• Each location can maintain different costs, selling prices, bin locations, etc.
• Only need to enter stock codes once, ability to maintain exceptions by location if required.
• When entering purchase orders, sales orders, supplier invoices or customer invoices ability to enter multiple stock locations in one transaction.
• Stock inquiries can be selected by individual location, in summary or detail.
• Stock inquiry can be consolidated for all locations.
• Stock reports can be selected by location.

Serial, Batch or Roll Tracking Option:
The Arrow serial tracking option provides the mechanism to easily and immediately identify, monitor and track the movement of stock items by their unique characteristic, being a serial number, batch or roll. This option integrates to all of the following Arrow modules; creditors, debtors, stock, purchase orders, sales orders, job costing and bill of materials. In manufacturing environments, when bill of materials is implemented, both raw materials and/or finished goods can be tracked by serial, batch or roll numbers

Serial tracking features include:

• Provides the ability to assess and track warranty claim conditions.
• Provides the ability during the manufacturing process to allocate serial/batch numbers to raw materials and finished goods,
• Optionally able to enter expiry dates and production batch details.
• Optionally allocate serial, batch or roll numbers during sales order entry.
• Optionally allocated serial, batch or roll numbers during production order entry.
• Actual cost of individual items can be monitored, and this cost can optionally be the basis for cost of sales calculation.
• Ability to have multiple bin locations per item.
• Global stock search by serial, batch or roll numbers.
• Provision to record adjustments against, serial, batch or roll numbers.
• Serial, batch, or roll number reports can be based on the status of individual numbers, including expiry date range, production batch range or quantity selections.

Advanced Sales Analysis Option:
The advanced sales reporting option includes a compilation of reports, dissecting sales statistics in a number of different ways. These reports have been designed to assist in the analysis and interpretation of sales data within Arrow.

Sales analysis reports include:

• Sales Code x Debtor Code. This report includes MTD and YTD sales quantity and value by sales code, by stock category. This report can be printed by sales code.
• Sales Code x Stock Category. This report includes MTD and YTD sales quantity and value by sales code by stock category. This report can be printed by sales code.
• Sales Code x Debtor Code x Stock Code. This report can be printed in summary or detail format, and includes MTD quantity and values, including a margin value and percentage. This report can be printed by sales code, customer code and stock category.
• Debtor Code x Sales Code. This report includes MTD and YTD sales quantity and value by debtor code by stock code. This report can be printed by debtor code.
• Debtor Code x Stock Code Monthly Detail. This report includes 12 individual months’ sales details by debtor code by stock code optionally printing quantity, value or both. This report can be printed by debtor code.
• Sales Code x Debtor x Stock Code. This report can be printed in detail or summary format, this report includes MTD and YTD sales quantity and value, including a margin value and percentage. This report can be printed by sales code.
• Sales x Stock Category x Stock Code. This report includes MTD and YTD sales quantity, sales value and cost including margin value and percentage by stock category or stock code. This report can be printed by stock code or stock category in stock code or alpha sequence, including supplier code.
• 12 Month Sales x Debtor Code. This report includes 12 individual months’ sales value for each debtor code, and calculates the sales value percentage that each debtor represents of the total sales value. This report can be printed by debtor code, in alpha or debtor code sequence.
• 12 Month Sales x Sales Code. This report includes 12 individual months’ sales value for each sales code by debtor code, and calculates the sales value percentage that each represents of the total sales value. This report can be printed by sales code in alpha or value sequence.
• Sales History Report. This report can be printed in summary or detail format. When selecting in detail format, individual transaction details listed include; date, invoice number and transaction type. This report can be printed by sales code by date range on either stock or debtor sequence.

Front Counter Option:
The front counter option provides the ability to process cash, account or counter sales. Payment methods can include cheque, credit card or cash. Optionally, a cash drawer, docket printer and barcode scanner can be configured to operate with the front counter option.

Front counter features include:

• Ability to enter multiple tender types: cash, cheque or credit card.
• Cash rounding.
• Docket printing.
• Fast data entry and processing.
• Online integration to debtors module for account sales.
• Online integration to cashbook module, maintaining banking deposit list and accurate bank balances.
• On line integration to stock module, maintaining accurate stock balances.
• Change required automatically calculated.
• End of day reconciliation report.

Data Transfer Option:
This option enables data to be transferred between locations. An example is where a national company has offices in every state, they are able to send and receive information between the branches and the head office. Data transfer can optionally integrate to the following modules; cashbook, debtors, stock, creditors, general ledger, sales orders, job cost, payroll and bill of materials.

Data transfer features include:

• Data can be transferred for selected or all modules with the option to transfer masterfiles, transaction or both.
• The system can be set to transfer data for a selected data range, the current period or for all previous untransferred data.
• Data can be sent between site electronically (ie over telephone lines via a modem) or on physical medial such as tape or diskette.
• The module allows the user to determine the frequency of data transmission eg information may be sent daily, weekly, fortnightly, monthly, etc.
• The data transfer module manages the integrity of the data. A detailed audit trial can be printed at the time of each upload and download showing all transactions, which have been transferred.
• Data transfer will handle any number of locations. Each site is identified by a unique three character text identifier that distinguishes one site from another.

Seagate Crystal Reports:
Seagate Crystal Reports is an award winning report writing tool, with over 3 million installed users world wide. Through the use of Arrow's Integrated Data Dictionaries, you don't need to set up complex formulas or selection criteria. Just drag and drop fields from Arrow into the report and then fine-tune the presentation. A design and a report preview windows let you see exactly with the report will look like.

• Data dictionaries mean the data is at your fingertips.
• Presentation quality reporting.
• Report experts lead you step by step to create perfect reports.
• Full control over formatting, colours and layout.
• Automatic graphing of report information in a multitude of styles.
• Drill-down information. Crystal allows for multiple levels of information within reports.
• Distribute reports by e-mail or export the information to Word or Excel, or print out hard copies.
• Parameter fields allow users to input information at the time of running reports, allowing the same report to be run for a day, a week, or a month.
• Easy in-depth reporting, grouping and sorting by data with Arrow.
• Ability to place reports onto the Arrow menu to customise your system.

QuickForm - Forms Manager: (learn more)
The QuickForm module is an easy to use forms manager for use with Arrow for Windows. It comprises an engine allowing automatic printing and automatic faxing, as well as an easy to use "drop and drag" windows look design area. This integrated module allows the creation, editing and output of standard stationery forms, such as invoices and statements to many different types of printers, including colour and black and white.

Features:

• Ready to use standard forms supplied.
• Black and white, and colour printing.
• Design your own stationery with the easy to use designer.
• Logo's/graphics can be placed anywhere.
• Print multiple copies to multiple printers - eg customer invoices on A4 and office copies on continuous paper on different printers.
• No need for preprinted forms.
• No wasted time swapping paper in printers.
• Print to dot matrix, bubble jet or laser.