Using the Bank Manager

Open the Cash Book

1. Go to Process then Cash Book and select Process Cash Book.
2. At the bottom-right corner of the screen, click Pastel Bank Manager.

Select Your Statement File

1. Statement Provider: Use the dropdown to select your bank.
2. Statement File: Click the browse button (… ) to select your bank statement.
3. Click OK.

Continue to Bank Manager

Click Continue to view your transactions in Bank Manager.

Search Function

The search feature only looks through the following fields:

• Statement Description
• Account
• Ledger Description
• Reference
• Project

Editing Transactions

You can manually edit certain fields in a transaction. However, you can change the Period and Amount fields.

Fields you can map are Account, Ledger Description, Tax, and Project.

Deleting Lines

1. Select the line then right-click and choose Delete Current Row.
2. Or to delete a sequence of lines, click the first line.
3. Hold Shift, then click the last line.
4. Or to delete non-continuous lines, hold Ctrl and click each line you want to delete.
5. Once selected, right-click and choose Delete Selected Rows.

Mapping Account Descriptions

Mapping automates recurring transactions. Many business transactions recur monthly, for example debit orders, supplier payments, and customer receipts.

1. Priority levels range from 1 (highest) to 10 (lowest).
2. Use unique and consistent phrases for accurate mapping.
   Example: A good mapping = bank charges.
                    A bad mapping = bank charges (3.45) as the amount will change monthly.
3. Select General Ledger, Customer, or Supplier and select the account.
4. Select the Tax Type and Project if applicable.
5. Right-click the line and choose Add Mapping.
6. You'll need to update the Ledger Description as needed.
7. Make your selections and click Save.

Configure Mappings

You can edit previously saved mappings.

1. Click any field to edit.
2. Make changes and click Save.
3. To apply changes to the current import, select Apply to Current Import.
4. Then select Overwrite All Mapped Transactions to update all mappings.

Splitting Transactions

Use this feature to divide a single transaction across multiple accounts.

1. Right-click the transaction and select Split Transaction.
2. Enter the split amounts and accounts.
3. Ensure the total equals the original transaction amount.
4. Click Save.

Both split transactions will appear in Bank Manager.

Exporting and Importing Batches

You can export batches to Excel, make changes, and re-import them into Bank Manager before posting to the Cash Book.

1. Export Receipt or Payment batches individually, or export all together.
2. Use the dropdown menu to select the batch type.

Mapped transactions use the following priority levels:

• High = 1
• Medium = 2
• Low = 3

Posting Transactions to Last Year

Bank Manager allows posting transactions to the previous financial year.

1. Go to Process then Cash Book and select Process Cash Book.
2. Click Settings and deselect This Year Transactions.
3. The bottom of the screen will show Last Year in red.

Using Tax in Bank Manager

1. Go to Settings and select Tax Processing.
   Ensure you change before importing your bank statement.

Moving Transactions to the Cash Book

1. Confirm you've selected the correct Cash Book (bottom-right corner).
2. Ensure you've selected all fields for all transactions.
3. Click Create Batch.
4. Finalise and click Update.

Other Notes

• If transaction dates fall in the current financial year, the system automatically assigns the correct period
• The system assigns Period 99 to transactions outside the financial year
• The bank Manager autogenerates the References using the format: day/month/unique number per day
• Bank manager sorts transactions into Payments and Receipts

If you need to add more users or companies to Sage 50cloud Pastel, leave your details, and we'll be in touch.