Never Under Estimate the Importance of Bank Reconciliation

Like it or not, businesses MUST diligently run Bank Reconciliation reports at least on a monthly basis. There is no excuse not to do it. If your business deals a lot with bank transactions, it can be a tedious exercise to go through the bank statement and tick off every single line. However, this painful task pays off since it will give you an idea of where your money have gone to and whether you are collecting enough.

UNITS has a built in feature to assist with Bank Reconciliation. It can be a bit confusing to start off especially if you don't regularly process your Bank Statement. Trust me it is a worthwhile thing to learn and regularly monitor. For those with access to internet banking, you can spare 15 minutes a day to reconcile. This will save you a lot of grief as compared to doing it once a month.

The downside to not monitoring your Bank Reconciliation is too hard to swallow. I know someone who learnt the hard way. By 'assuming' that this is being done correctly, a company has lost a huge sum of money over a period of about 6 months!!! Bank Statements were not reconciled and neither were Debtors and Creditors.

There are many ways to beat a system but it is not easy to manipulate Bank Statements. So please monitor them closely and tie them up with postings in the system.

Excel: Ctrl + [SpaceBar] & Shift + [SpaceBar]

I recently found out about this amazing keyboard trick on Excel.

Select any cell on your worksheet.
Press Ctrl + [SpaceBar]
Excel will highlight the whole column!

Select a different cell on the worksheet.
Press Shift + [SpaceBar]
Excel highlights the whole row!

Press Ctrl+Shift+[SpaceBar] and Excel highlights the whole worksheet!

Neat!

Unable to Save As PDF in UNITS

If you face a problem where you are unable to save any reports as PDF, it is quite likely that your PDF Export Driver is corrupted. Take the following steps to fix it.

1.       In the run box type "%UNITS2%seinstall.exe" "Auto-IT SMARTExport Driver" –u

2.       Go to the Printer and Faxes folder in Control Panel and delete the Auto-IT SMARTExport Driver and Amyumi PDF converter if they are found.

3.       Reboot the PC - IMPORTANT STEP

4.       Delete the following highlighted dlls if they exist in the following folders (check for all these files in each of the folders, the last folder might not exist on the server):

C:\WINDOWS\system32

C:\WINDOWS\system32\spool\drivers\w32x86

C:\WINDOWS\system32\spool\drivers\w32x86\3

C:\Windows\System32\spool\drivers\w32x86\3\amyuni_amyunidocumentconverter400

5.       In the run box type "%UNITS2%seinstall.exe" "Auto-IT SMARTExport Driver"

6.       Test the PDF driver in Units/Equip again.

Sometimes, you can get away with just running steps 1 (to uninstall) and 5 (to reinstall). You may want to try these two steps first. If it doesn't work, you should run the whole steps in detail.