Introduction

Repos

Sample CSVs

Journal Processing

Procedure

  1. Journal processing under the Import Transactions extension is currently the equivalent of a General Journal not a Debtors Journal or a Creditors Journal that may be found in other accounting software packages.
  2. You have probably noticed under FA...Banking and General Ledger...Journal Entry there is no provision for creating a journal matched to a specific customer or supplier.
  3. Hence, account codes relative to the General Ledger should only be used here.
  4. The Debtors Control account and Creditors Control account are General Ledger accounts and can be used in the extension. The person_id eg. 1 for Joe Bloggs and person_type_id eg. 2 for Customers (Supplier =1) are currently simply used to extract information ie. customer name from the database and put it into a memo.
  5. Currently supplier payments are allocated using the extensions Payment Processing not Journal Processing.
  6. Allocate receipts using the extensions Deposit Processing. The Sales Ledger is updated and the amount(s) await to be allocated under FA/Sales/Allocate Customer Payments or Credit Notes.
  7. If the Purchases Ledger is updated on import, then amount(s) await to be allocated under FA/Purchases/Allocate Supplier Payments or Credit Notes. This is where you will find evidence of the success of the import.

General Journal Processing

  • Double entry using General Ledger Account codes.
  • This implies the exclusion of Debtor and Creditor processing.

Sales Order / Sales Invoice Processing

  • Import multi-line or single line sales orders/invoices from a csv/spreadsheet.
  • Import either cash invoices (payment_id normally 4) or credit invoices (payment_id normally in the range of 1,2 or 3)
  • Use the payment_id lookup tool to determine what id you will use.
  • Cash invoices will generate a Delivery note, Sales Order, Petty Cash Payment, and Sales Invoice automatically.
  • Credit invoices will generate a Delivery note, Sales Order, and Sales Invoice automatically.
  • Templates are provided in the templates folder.
  • Equivalent to Debtor/Customer Journal Processing.

Purchase Invoice Processing

  • Under development

Bank Statement Processing

Procedure

  • Download your bank statement in csv format.
  • Typically your bank statement csv will have 4 columns, from left to right, namely; date, memo, payment, and receipt.

Preparing your spreadsheet

  • Your first spreadsheet column should be a reference.
  • The next four columns should be your bank statement's columns namely date, memo, payment, and receipt.
    • Verify that the date format in your csv corresponds to the date format used in Front Accounting.
      • This setting can be verified under Setup->Display Setup->Dateformat and Separators.
  • Add additional columns namely account code, taxtype, dim1ref, dim2ref, person_type_id, person_id, Branch_No
    • Account code: eg. 4000 Sales which can be retrieved using the extensions lookup tool.
    • Taxtype: eg. 1 VAT 20% Which can be retrieved using the extensions lookup tool.
    • Dim1ref and dim2ref if you are using cost centers. Normally left blank.
    • Person_type_id can only be either 1 or 2. Customer = 2, and Supplier = 1.
      • So if an amount is in the payment column you will normally have a 1 in the person_type_id column,
      • and if an amount is in the receipt column you will normally have a 2 in this column however a reimbursement from a Supplier for an overpayment to a Supplier can be processed so a 2 can appear under person_type_id if an amount is in the deposit column.
    • Person_id is a Customer or Supplier specific number that is retrieved using the lookup tool.
    • Branch_No is the customer branch.

Using the Extension

  • If bank statement check box is checked it means:
    • You are using the above prepared two amount column spreadsheet.
    • You will have to process your prepared spreadsheet/csv once with 'Deposit Processing' so that Deposits only are processed and a second time with 'Payment processing' so that Payments are processed.

After using the Extension

  • The Sales Ledger has been updated and the amount(s) await to be allocated to an invoice under Sales/Allocate Customer Payments or Credit Notes.
  • The Purchases Ledger has been updated and the amount(s) await to be allocated to an invoice under Purchases/Allocate Supplier Payments or Credit Notes.