| Sheet |
Summary |
|
Nominal Ledger Journal
|
Allows for the import of NL Journals. Ability to create journal transactions including reversing, recurring and previous journals.
|
|
CB Cash - Cash Receipts and Payments
|
Allows for the creation of nominal vatable receipts and payments and nominal non-vatable receipts and payments.
Supports bank accounts or nominal codes.
Browse capability on key fields.
|
|
Sales Ledger Invoice
|
Allows for the posting of Sales Ledger Invoices and/or credit notes against the Sales Ledger and the ability to browse on relevant account codes and post into the Sales Ledger.
Supports transaction analysis codes, the validation of reference and second reference, and the creation of opening balance transactions.
Ability to set the query flag on creation.
|
|
Purchase Ledger Invoice
|
Allows for the posting of Purchase Ledger Invoices and/or credit notes against the Purchase Ledger and the ability to browse on relevant account codes and post into the Purchase Ledger.
Supports transaction analysis codes, the validation of reference and second reference, and the creation of opening balance transactions.
Also provides the ability to set the query flag on creation.
|
|
Sales Orders
|
Create, download and amend Sales Orders in Sage including mapping of analysis codes.
Also provides the ability to convert a quote to an order.
Supported transaction types are order, quote, return and proforma.
|
|
Sales Ledger Cash
|
Allows the user to enter SL cash items in to Excel to create either unallocated or allocated payments and/or receipts.
When allocating, provides the ability to either match manually or choose to automatically match based on references, an exact value or oldest first. The user is then able to associate each cash payment/receipt with the correct invoice.
Also supports grouped transactions.
|
|
Purchase Ledger Cash
|
Allows the user to enter PL cash items in to Excel to create either unallocated or allocated payments and/or receipts.
When allocating, provides the ability to either match manually or choose to automatically match based on references, an exact value or oldest first. The user is then able to associate each cash payment/receipt with the correct invoice.
Also supports grouped transactions.
|
|
Project cost adjustments
|
Post cost and revenue adjustments to projects. If costs are posted to the wrong project, these can be adjusted to the appropriate project. Mispostings can also be adjusted quickly and easily.
Supports transactional analysis codes.
|
|
Purchase Orders
|
Create, download and amend Purchase Orders in Sage including mapping of analysis codes.
Supports the ability to print the Purchase Order.
Supported transaction types are order and return.
|
|
Inter Account Transfer
|
Allows for the recording of bank transfers between accounts replicating the functionality of the Cashbook Inter Account Transfers option within Sage 200. Allows the user to record the movement of money from one account to another, including foreign currency transfers with exchange rates, capture commissions and record nominal postings.
|
|
Stock Master
|
Used to create, download and amend stock records, including the ability to upload to multiple warehouse combinations without the need to split the upload by warehouse. Enables the ability to create bins and populate the legislative information.
The sheet supports the supplier, memo, search category and analysis code tabs allowing multiple entries for each plus support for pricing, units of measure and batch information.
The amendment also allows the changing of the stock product group.
|
|
Stock Transfer
|
Replicates the functionality of the Transfer Stock option in Sage allowing for multiple transfers of stock from one location to another, in a single upload.
|
|
Sales Ledger Allocation
|
Replicates the Allocation option within the Sales Ledger in Sage 200 allowing the user to allocate existing open items.
Also allows automatic allocation by date.
|
|
Project Accounting
|
Allows for the creation, download and amendment of projects.
Supports the following tabs - details, costs and charges, contact info, memo, nominal defaults, additional information, budgets by period, customer billing details and billing schedule.
|
|
Sales Order Invoice
|
Replicates the functionality of Sales Order Invoice from the invoicing option within Sage 200 allowing for the creation of invoices or credit notes.
|
|
Bill of Materials
|
Allows users to create, update and delete Bills of Materials. The sheet features a download function which allows one or more BOMs to be downloaded into the sheet, this makes editing or copying a BOM much easier.
Operations, Resources, components, Sub Contract details, Analysis Codes can all be specified for a create or amended on an existing BOM.
Version control details can also be specified if enabled in Sage.
|
|
Sales Ledger Customer
|
Allows for the creation, download, amendment or deletion of Sales Ledger Customers.
|
|
Purchase Ledger Supplier
|
Allows for the creation, download, amendment or deletion of Purchase Ledger Suppliers.
|
|
Purchase Ledger Allocation
|
Replicates the Allocation option within the Purchase Ledger in Sage 200 allowing the user to allocate existing open items.
Also allows automatic allocation by date.
|
|
Stocktake
|
Replicates the ‘enter values’ function of the manage stocktake option within Sage 200. Following creation of the stocktake card, allows the user to download the stock card into the sheet where they can enter the values and update the card from the comfort of Excel, back into Sage 200.
For non-traceable items, the user can choose to complete the stocktake card, replicating the completion functionality within Sage 200. For traceable items, this sheet enhances the functionality of Sage 200, allowing the user to download the stocktake card with a full itemised breakdown of batch and/or serial numbers. The user can then enter values at the batch/serial level and then complete the card which will perform the necessary stock movements (i.e. add stock or write off stock) in Sage.
|
|
Stock Movements
|
Allows the user to add or write off stock in accordance with the Sage ‘add stock’/’write off stock options’, enabling users to adjust stock levels without requiring a full stock take process.
|
|
Purchase Order Receipt
|
Replicates the Confirm Goods Received option in Sage 200, allowing for the creation of Purchase Order Receipts.
|
