Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Select the date, this will be the date that will appear in the  Bank Reconciliation Report (BANK RECON REPORT MANUAL ) as being the collection date.
  2. Select the Ledger, Group, and Account for your entry. You can also just select the account name directly, and the related Ledger and group will be shown. In this case, I selected the account Ap Trade". The pop will appear. The selection of an account might vary based on the property's COA of the property.
  3. You can search by Supplier supplier name or by cheque number. 
  4. Click on the search icon.
  5. Select the payment that you want to reconcile by ticking the box.
  6. Click "Submit" when done.

...

Credit Side Entry

  1. Key in the reference Reference Number.
  2. Select the date of the transaction.
  3. Select the Ledger, Group, and Account for your entry. You can also just select the account name directly, and the related Ledger ledger and group will be shown. In this case, I selected the account Credit card clearing". The pop will appear. The selection of an account might vary based on the property's COA of the property.
  4. Transactions that have not been cleared yet will be shown, you can also search based on transaction number or approval code.  
  5. Select the transaction that you want to clear, you can also select all transactions by clicking the select all button.
  6. Click "Submit" when done. After submitsubmission, the selected transactions will be shown automatically on the credit side column.

A new filter has been added, you can now search by batch number. 

Image Added


Debit Side Entry

  1. Select the Ledger, Group, and Account for your entry. You can also just select the account name directly, and the related Ledger and group will be shown. In this case, I selected the account Credit card clearing". The pop will appear. The selection of an account might vary based on the property's COA of the property.
  2. Enter the amount that you received in the bank, excluding the credit card charges or commission.
  3. Select the "debit" button.
  4. Select if it's tax incl included or excl and the related taxes if applicable.
  5. Enter the memo for this journal.
  6. Click + record when done. 
  7. For credit card clearing you also have to debit your credit card charges. When or if the chosen account is a P&L account, division Division and department Department are mandatory. For the credit card commission entry repeat Repeat steps 1 to 6 after selecting the department for the credit card commission entry. (see image 2)
  8. Click "Submit" when done. After submitsubmission, the selected transactions will be shown automatically on the credit side column.

...

Before you can clear it, the cheque needs to be deposited first. When you bring the cheque to the bank you have to perform a few steps in the AR Reconciliation program.
AR Reconciliation programthis is where you assign the cheque, which bank the cheque should go to. (This also creates a journal entry on your GL, debit bank credit cheque clearing and the date that will appear on your AR report will be 0000-00-00 until you perform the cheque clearing and the collection date will be shown).  AR RECONCILIATION MANUAL

The collection date is very important because this is the date that will appear on your AR report as your formal payment date of payment.

  1. Select the collection Collection Date. This will be the date that will appear in the  Bank Reconciliation Report (BANK RECON REPORT MANUAL ) as being the collection date.
  2. Select the Ledger, Group, and Account for your entry. You can also just select the account name directly, and the related Ledger and group will be shown. In this case, I selected the account"cheque clearing". The pop will appear. The selection of an account might vary based on the property's COA of the property.
  3. Select the cheque you want to reconcile/knock off.
  4. Then click the submit button when done.

...