The Bookkeepers Solution....using modern technology....
Download
1 / 88

The Bookkeepers Solution...ing modern technology.... - PowerPoint PPT Presentation


  • 126 Views
  • Uploaded on

The Bookkeepers Solution....using modern technology. Writing up Cash Books the SmartBank way!. Step by Step – Summary. Step 1) Download Bank Statement files Step 2) Open SmartBank Step 3) Import Bank Statement file into SmartBank

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'The Bookkeepers Solution...ing modern technology....' - dalit


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript


Step by step summary
Step by Step – Summary

  • Step 1) Download Bank Statement files

  • Step 2) Open SmartBank

  • Step 3) Import Bank Statement file into SmartBank

  • Step 4) Allocate (Auto) & Edit ledger transactions

  • Step 5) Export the allocated transactions

  • Step 6) Import into Accounting package(e.g.Pastel)

  • -> Direct Import to Pastel coming soon...


Step 1 download bank statement files
Step 1) Download Bank Statement files

SmartBank can import (NOT PDF):

1) OFX +. OFC Files

- Secure files

- Each line has unique number

- Avoids duplication of transactions

SmartBank can 1) View and 2) Print downloaded OFX and OFC bank statement files (Pastel cannot view and print OFX/OFC files until imported)

  • 2) CSV Files – to be updated soon

  • Only use as last resort (ABSA problem)

  • Cannot recognise duplicate transactions

SmartBank will accommodate new bank formats as and when requested or required


Download bank statement files ofx ofc csv from internet bank account
Download Bank Statement files (.OFX/.OFC/.CSV) from Internet Bank Account

Search for .OFX/.OFC Preferably (CSV as last resort)

SmartBank can:

- VIEW and PRINT OFX and OFX/OFC files- Recognises and avoids duplicate transactions


Rename save file on harddrive
Rename & Save file on Bank Account harddrive


After downloading click on the ofx or ofc file and view using smartbank
After downloading Bank Account Click on the OFX or OFC file and view using SmartBank



Step 2 open smartbank
Step 2 Open SmartBank Bank Account





Add company remove
Add Company (+Remove) Bank Account

Open Company

Browse C drive or Server

ANY Pastel version


The bookkeepers solution ing modern technology

SmartBank – Before Import of Bank Statement file Bank Account

SmartBank has 4 menus

1) Top menu

2) Tool Bar menu

3) Filter menu

4) Transaction menu


The bookkeepers solution ing modern technology

SmartBank MENUS Bank Account



Top menu
Top Menu Bank Account

The TOP MENU consists of the following helpful SmartBank tools:

  • Open Company - From inside SmartBank – Move from 1 company to another

  • Help - Help Menu

  • Change - Abbreviations

  • Maintenance - Global processes including:

    1) Delete either the LAST Imported batch or

    2) ALL the transactions for a specific bank Account


The bookkeepers solution ing modern technology

Open Company – Using Bank Account TOP Menu Move from 1 company to another

Help Menu


The bookkeepers solution ing modern technology

Change – Bank Account Abbreviations

  • Maintenance - Global Processes – Delete Imported Bank Statement Batches

Delete Last Imported Batch - will ONLY delete last imported batch

VERY IMPORTANT!!Delete ALL transactions for Account 11234564, will delete ALL THE HSITORY for this bank account.


Tool bar menu
TOOL BAR MENU Bank Account

Statement In - Import

Change – Edit / Process


The bookkeepers solution ing modern technology

View - Bank Account Reports

Tools – Settings

Tools – Auto Allocation


The bookkeepers solution ing modern technology

Statement Out - Bank Account Export

Help


Bank filter display options
BANK FILTER & DISPLAY OPTIONS Bank Account

Bank Account

SmartBank can work with Multiple Bank Accounts being used at the same time.

Displayed List

  • Best to work separately re

  • Deposits Only or

  • Withdrawals Only and then

  • View ALL Transactions

    • -> Final review+ Export


The bookkeepers solution ing modern technology

Batch Mode Bank Account

Default mode is - “Show Only the last batch”.

The user can also select - “Show all batches imported”

Date Range

Note that SmartBank’s Export files are also controlled by the start date and end dates on the date Range



Transactions menu detail
Transactions menu detail Bank Account

Imported from Bank Statement

- Date - Bank Statement

- Bank Description - Bank Statement

- Amount - Bank Statement

Manually / Auto Allocated by user

  • - Exp -  - Export this Transaction – Ticked () by Default–> Unticked will NOT Export by default

    - GCS - G - General ledger - C - Customer - S - Supplier

    - Account - Allocated to GCS account

    - Tax (Vat) - If Applicable

  • Ledger Description - Edit if required

  • Account description - Generated by SmartBank after Account allocated

    - Reference - Generated by SmartBank

    - Cost code - Cost or Project Code – if required

    - Rec -  - Record as Reconciled – Default is NOT Ticked as this field is not used in Pastel


The bookkeepers solution ing modern technology

SmartBank MENUS Bank Account


Step 3 import bank statement file
Step 3 Bank Account Import Bank Statement file


1 browse for bank file to import ofx ofc prefs csv files ok
1) Browse for bank file to import Bank Account -> OFX/OFC Prefs (CSV files ok)


2 select cash book account
2) Bank Account Select Cash Book account

The bank account selected here stays as the default account for this account number.Thereafter, SmartBank will ONLY import Statements with this account number for this bank account.




Then accept and smartbank will import the bank statement as follows
Then Bank Account “Accept” and SmartBank will import the Bank Statement as follows:



Edit allocate transactions
Edit & Allocate transactions Bank Account

  • Deposits – BLUE

  • Withdrawals / Payments - BLACK

  • Editing includes

    • Allocating to:

      • Ledger, Customers & Suppliers accounts

      • Vat – if applicable

    • Editing Ledger Description

      • – if required (Pastel-> Max 40 characters

    • Cost centre & References if required


Select display list deposits only
Select – Display List - Bank Account Deposits Only


Select display list withdrawals payments only
Select– Display List – Bank Account Withdrawals/Payments Only


Edit and processing tools snapshot
Edit and Processing Tools Snapshot Bank Account

EDIT MENU

Right Click – Pop Up Transaction menu

Process menu


Edit menu
Edit Menu Bank Account



Split current transaction
Split Current Transaction Bank Account

Edit the transaction pop up window as follows using a) to e) below


The bookkeepers solution ing modern technology

Then the transaction split appears as follows: Bank Account

In a same manner, similar transactions can be grossed up & split as follows:

R3000 is allocated to the Customer – 600 discount etc = R 2200 net


Remove current split transaction
Remove Current Split Transaction Bank Account

  • First click on the transaction line that needs to be Removed or Edited as follows:

The same Split Transaction window pops up.


The bookkeepers solution ing modern technology

Then removed row is shown as follows: Bank Account

Then follow steps 4) to 7) as shown below:



Search
Search Bank Account


Clear screen
Clear Screen Bank Account

CLEAR SCREEN option will clear the screen of previous batches imported but will NOT delete it.


Copy paste
Copy & Paste Bank Account

Edit menu - Copy (Ctrl C) and Paste (Ctrl V) or

Using Mouse - Right Click, Copy and then Paste:


Process menu
PROCESS MENU Bank Account


Save whole or part of bank description for auto allocation
Save Whole or part of Bank Description for Auto Allocation Bank Account

See Auto Allocation below:


Fill blank accounts with defaults
Fill blank accounts with Defaults Bank Account

Will Auto Allocate ALL the unallocated Ledger accounts to the “Default Account Codes”

for unallocated “Deposits” or “Withdrawals”suspense accounts in the accounting

package being exported into.


The bookkeepers solution ing modern technology

Blank Accounts Bank Account

Filled with default Suspense Accounts


Reconcile menu options
Reconcile Menu Options Bank Account

  • NOT used for Pastel

  • Additional field if required:

    • for Export/Data sort

    • Export to Excel etc


Export allocated accounts only
Export – Bank Account Allocated Accounts Only


Let smartbank intelligently speed up allocations editing with
Let SmartBank Intelligently Bank Account Speed up Allocations & Editing with:

  • Sort Columns - Match like items

  • Auto Allocate - Saving & Auto Allocating Recurring transactions

  • Abbreviations - Ledger Descriptions

  • Copy / Paste - Ledger Accounts & “Descriptions”


Select display list sorting columns deposits or withdrawals only
Select Bank Account Display List + Sorting Columns -> Deposits or Withdrawals Only

Select transaction from Display List

Sort and match like transactions by Date or Bank Descriptions

Start Allocating and editing transactions


Auto allocation list saving recurring transactions
“Auto Allocation List” Bank Account -> Saving Recurring transactions

Step 1 - Allocate and fully EDIT the FIRST transaction

Step 2 - Highlight the Recurring Whole or Part of the “Bank Description”

Step 3 - Select “Save Whole or Part” of the Bank Description for Auto Allocation”

The saved recurring transaction will be SAVED to the Auto Allocation menu as follows:


The bookkeepers solution ing modern technology

Step 1 - Allocate and fully EDIT the FIRST transaction Bank Account

  • Allocate the a) Ledger account b) Tax code(if applicable) in the FIRST transaction

  • Edit the “Account Description”if required for the Ledger account being allocated

  • If required, edit the Reference and Cost Code

Step 2 - Highlight the Recurring Whole or Part of the “Bank Description”


The bookkeepers solution ing modern technology

Step 3 - Select Bank Account “Save Whole or Part” of the Bank Description for Auto Allocation”

  • - Right Clicking after highlighting the selected whole of part of the Bank Description.

    - Process and then “Save Whole or Part” of the Bank Description for Auto Allocation”

All the current batch transactions will be “Auto Allocated”


The bookkeepers solution ing modern technology

The transaction will be SAVED to the Auto Allocate List as follows:

The next bank statement import will Auto Allocate the SAVED transactions as follows:


Abbreviations
Abbreviations follows:

Abbreviations – Set-up, Editing and storing


Copy paste1
Copy & Paste follows:

Edit menu - Copy (Ctrl C) and Paste (Ctrl V) or

Using Mouse - Right Click, Copy and then Paste:


Ready to export check list
Ready to Export – Check list: follows:

1) All required transactions are ALLOCATED to Ledger ACCOUNTS (GCS)

2) All Allocated transactions are TICKED ()

3) All UNALLOCATED transactions not to be Exported are UNTICKED()


Before exporting display menu settings are nnb
Before EXPORTING follows:–> Display menu Settings are NNB:

If set on:

  • Show ALL Transactions

    • BOTHWITHDRAWALSANDDEPOSITS will be Exported

  • DEPOSITS Only

    • ONLYDEPOSITSwill be Exported

  • WITHDRAWALS Only

    • ONLY WITHDRAWALSwill be Exported


Step 5 export deposits payments batches from smart bank
Step 5) Export follows:Deposits &Payments batches from Smart Bank



2 browse location rename file
2) Browse follows:Location+Rename File

Default folder location

“To Import”

Step 1) “Browse Location” – will default to the subfolder “To Export” of the Pastel company. Any alternative folder entered will

become the new default folder

Step 2) Select and edit the File Name to be Exported manually.

Note: The above steps, which are currently combined, will be made into 2 separate Steps in the near future


3 ready to export
3) Ready to Export follows:

  • Export also includes Options to:

  • “Print Statement” / Document of files to be exported

  • Archive Exported to History

    • -> Saves all exported transaction to SmartBank History


Export completed
Export completed follows:

By default, the files will be Exported to the “To Import” sub folder of the company


4a locating viewing exported files
4a) Locating viewing Exported files follows:

To VIEW and see the CONTENT of the exported file, go to the “To Import” folder and view the “CBPymt+Date+Time” and the “CBRept+Date+Time” files CSV format as follows:


4b viewing exported batch in smartbank
4b) Viewing follows:exported batch in SmartBank


Step 5 process after export options
Step 5 – Process “After Export” Options follows:

  • “Print Statement”- Print a statement summary of the files exported

  • “Archive Exported to history”- Will freeze the transactions and - Will be removed from the active list and -Saved to the Archive History file on SmartBank.


Export error messages and solutions
Export error messages and solutions follows:

  • Ledger Descriptions longer than 40 characters

  • Blank or Entry Account codes that have not been allocated

Either: 1) Allocate All the Blank or Allocated Accounts Or 2) UNTICK ALL the accounts that are Blank or unallocated and should NOT BE EXPORTED


The bookkeepers solution ing modern technology

Export error messages and solutions (continued) follows:

Date out of Financial Year


Step 6 importing into accounting package
Step 6) Importing into Accounting Package follows:

  • Choose the correct Cashbook Payments or Deposits screen

  • Click on “Batch” and then “Import” at the bottom of the page

  • 3) Select the correct file Exported from SmartBank


The bookkeepers solution ing modern technology

4) Click on “Import” follows:

5) Click on “Process”

6) Check imported Payments and Deposits :

a) Transactions

b) Totals

7) Do a manual Reconciliation:

a) Before Import

b) After Import


Step 6 import the cashbook files into your accounting package e g pastel
Step follows:6) Import the Cashbook files into your accounting package (e.g. Pastel)




Smartbank is ideal for
SmartBank is ideal for: follows:

  • Any small, medium or large business

  • With lots of Cashbook and Credit Card transactions to process

  • Accounting and Bookkeeping businesses using:

    • Using any of the multiple accounting packages

    • Lots of bank statement transactions to process


Pastel charges are follows
Pastel charges are follows: follows:

  • Forced to take support contract on ALL Pastel modules

  • Must upgrade to the latest Pastel version V11

    Pastel costs:

    • R2550 for Bank manager

    • + R1060 per year thereafter

    • Compulsory Cover -> Costing another R2600 to R5000 a year and more


Smartbank costs only
SmartBank costs only: follows:

  • R1600 per PC

  • R900 per year thereafter

  • Free self help

    • Free Manuals

    • Videos

    • Frequently asked questions

    • And more

  • Telephonic and onsite support is separate and optional

    • at R500 ishper hour

    • JHB support centre is in the process of being set-up


  • Downloading bank transaction history files is the key
    Downloading bank transaction history files is the KEY! follows:

    • Nedbank is the only bank that can go back 30 months or more

    • Other Banks can only 3 to 6 months

    • Solution

      • Teach / Educate clients into this new way of thinking!

      • Ensure clients to regularly download Bank statement files daily, weekly monthly or bi monthly

      • Rename files meaningfully

      • Save and backup downloaded Bank files in a regular folder on C: drive


    Downloading bank transaction history files is the key1
    Downloading bank transaction history files is the KEY! follows:

    • Nedbank is the only bank that can go back 30 months or more

    • Other Banks can only up to 6 months

    • Solution

      • Teach + ensure clients download Bank statement monthly or bi monthly

      • Rename files meaningfully

      • Save in a regular folder


    The future of accounting
    The future of Accounting... follows:

    • Electronic processing is the only solution...

    • Bank statement downloading and storage to:

      • Become the norm

      • Banks need to keep history – 3 to 5 years

      • Clients need to download and save OFX and OFC files monthly (CSV is a fallback option)

      • Accountants must EDUCATE and HELP clients

        ...to the NEW way of Accounting!!


    Smartbank solution pty ltd
    SmartBank Solution (Pty) Ltd follows:

    Directors - David Hartley and Syvain NtumbaReg No: 2012/097293/0726 Country Club Road P O Box 45100Kenilworth, 7800 Claremont, 7945

    • Phone    +27 (0)82 06 12300 / 021 – 683 8333Fax        +27 (0)86 684 8660Email     info@smartbank.co.za

      Website www.smartbank.co.za

    • JohannesburgTo be announced soon