Bank Reconciliation’s recurring entry saves time (O)
Does your bank charge the same fees each month? Or, do you have certain recurring payments automatically deducted from your bank account each month?
To save yourself time with data entry as well as a reminder to enter these monthly recurring entries in Bank Reconciliation, use the ‘Recurring Adjustment’ feature in Bank Reconciliation.
In Bank Reconciliation-> File Maintenance-> Recurring Adjustments, select the bank account for the adjustment, enter the Adjustment ID and dollar amount to be deducted. Next, enter the debit or debits that these amounts will be expensed to.
When you enter Bank Reconciliation Transactions, enter the Bank ID and the Transaction Type of Adjustment. To copy in a recurring adjustment enter an “*” with the Adjustment ID you set up in File Maintenance. (For example if you set up a recurring adjustment as FEE enter *FEE) You will then be prompted to copy in this recurring adjustment. You can then edit or leave as is before posting.
Protecting your computer from ‘malware’
It seems like only yesterday when viruses and spyware were at the top of the list of PC annoyances. Today, the evolution takes us to its next kin…Malware. With malware, all you need to do is make one wrong click and *BAM*, you’re infected and there is little left to do with your PC other than call your computer tech and wait until it’s remedied.
There are no tools available right now that can proactively protect you from certain infections because they are “click induced”. This means that the spreading of infection requires that you CLICK on something to trigger the install of this malicious software. You may remember when “Yes”, “No”, and the red “X” actually meant something. Today, all of them equal a single keystroke…”Yes”.
There is, however, a very effective way of avoiding this headache. With these simple steps, you may be able to walk away from that infected website unscathed.
1- At the first sign of infection, it is very important to close out of the window BEFORE it has the chance to spread to your machine. The way to do this is by closing the window WITHOUT actually clicking in the pop-up window. The time it takes to do this is not important because (again) the malware is waiting for your click to advance.
2- To exit a window before infection, press Ctrl+Alt+Del before clicking anywhere else. Once you do this, a list of actions will come up. Click on the Task Manager. Once the Task Manager appears, click on the tab labeled “Processes”. Under the category “Image Name”, you’ll notice a long list of running applications. Look for the following processes:
- iexplore.exe – Internet Explorer
- firefox.exe – Mozilla Firefox
- chrome.exe – Google Chrome
3- Click on the above process once and then click the “End Process” button. Make sure you get them all, as there are normally more than one instance.
If you manage to do this without first clicking in the annoying pop-up threat, you may have just saved yourself a meeting with your tech.
Tracking sales rep commissions (O/T)
Keeping up with sales rep commissions can be an arduous task if you are not using the built-in commissions function found in Accounts Receivable.
Commissions due can be calculated based on:
- ‘booked sales’ (when the sale is posted) or when the customer has ‘paid’ the invoice
- percentage of the entire invoice - or percentage of the gross profit of the invoice
- individual line items of an invoice
Also, two Sales Reps can also ‘share’ in the commissions for a particular invoice.
Clearing old uncleared checks (Q)
If you have outstanding checks from previous years that have never cleared, and feel confident that they never will clear, what’s the best way of getting rid of them? You don’t want to void checks from previous years, as that will make your year-end balance different from your beginning year balance, and may cause your CPA to charge you extra to figure it out.
Here’s a simple work-around:
- Instead of voiding a transaction from the previous year, enter a deposit using the current date
- Use the same payee, the same amount, and the same expense account as the check you wanted to void.
- When you reconcile the bank account clear both the outstanding check and the deposit you created. Since they “wash” each other, they don’t change the reconciled balance.


