Cashbook for Sage 300cloud

Product Tips

Cashbook

Requirement: I need to unreconcile a range of entries in my bank reconciliation.

Solution: Unreconcile a range of entries in the bank reconciliation by doing the following:

1. Select Reconcile Range from the menu
2. Select the range of Cashbook entries you wish to unreconcile
3. Click on the expand icon
4. Tick the "Open All reconciled" option and select the "Unreconcile" button

Product Tips

RecXpress

Requirement: I need to add a new rule on the fly.

Solution: All imported bank statement entries that do not have rules are assigned to the Category "OTHER".

To add a rule on the fly, do the following:

1. In the RecXpress reconciliation select to display the "No Match" Import Status.
2. Use the Category filter at the top of the reconciliation form and select the Category "OTHER" to display all bank statement entries with no Rules.
3. Setup the default GL Account, Source Code, Tax, and Accounts Payable or Accounts Receivable allocation details to use when the entry is generated.
4. Change the Category from "OTHER" to a Category of your choice on the bank statement entry detail line.
5. When prompted "You have changed the Category from OTHER to XXXXX. Do you want to add this entry to Category XXXXX in your Rules Template?" Select Yes to save the new Rule to the Rules Template.
6. You are then prompted "Successfully added Category XXXXX. Would you like to edit this entry’s defaults?" Select Yes.
7. Edit the new Rule’s Compare Method and Compare Description to make it more specific.
8. Select the "Refresh" button to apply this Rule to all entries in Category "OTHER" that match the Rule criteria.
9. Select Yes when prompted "Are you sure you want to refresh the imported reconciliation?"

The entries are moved to the Category defined in the new Rule.