Skip to content

Cash Book Payments

Introduction

Cash Book Payment Excelerator allows Sage 200 Payments to be entered in Excel.

Please check out this tutorial.

Info

To use Cash Book Vatable Payment Excelerator, the user must have access to the "Nominal Vatable Payment" feature in Sage.

To use Cash Book Non-Vatable Payment Excelerator, the user must have access to the "Nominal Non-Vatable Payment" feature in Sage.

See also: Sage 200 Configuration

Standard templates

Templates are working examples of Excel worksheets for use with Excelerator. You can use the standard templates as they are, amend them using the Template Designer, or create your own templates from scratch.

Codis provides a single template workbook: S200CBPaymentTemplate.xlsx. This includes sheets which allow:

  • Single_NonVAT-LocalCurr - Entry of a single Non-VAT Cash book payment into local (base) currency bank accounts on a worksheet.
  • Single_VAT-LocalCurr - Entry of a single VAT Cash book payment into local (base) currency bank accounts on a worksheet.
  • Multiple_NonVAT-LocalCur - Entry of multiple Non-VAT Cash book payments into local (base) currency bank accounts on a worksheet.
  • Multiple_VAT-LocalCurr - Entry of multiple VAT Cash book payments into local (base) currency bank accounts on a worksheet.
  • Single_NonVAT-ForeignCurr - Entry of single Non-VAT Cashbook payment into foreign currency bank accounts on a worksheet.
  • Single_VAT-ForeignCurr - Entry of single VAT Cashbook payment into foreign currency bank accounts on a worksheet.
  • Multiple_NonVAT-ForeignCurr - Entry of Non-VAT multiple Cashbook payments into foreign currency bank accounts on a worksheet.
  • Multiple_VAT-ForeignCurr - Entry of VAT multiple Cashbook payments into foreign currency bank accounts on a worksheet.

Options

Don't clear header ranges

If this is ticked, when the Clear All menu option is selected, the header ranges (single cell ranges) will not be cleared.

Ignore payments having zero gross amount

If this option is not ticked, any zero gross amount payments found will be treated as an error.

If this option is ticked, any zero gross amount payments found will be ignored.

Saving

You can use Standard template (S200CBPaymentTemplate.xlsx) or create your own templates also for Cash Book payments. The multiple tabs in template are mentioned above.

Calculate Values

The Calculate Values option will populate values on your cask book payment. Values already entered will not be overwritten.

As values (Gross/Goods) can depend on the bank currency, these should be entered before clicking the Calculate Values button.