LedgerBLOG

Error on Last Day of Period

Software: MoneyWorks accounting software

When creating a transaction, such as Sales Invoice or Purchase Invoice, the last day of period was wrongly stated (see below image).

In the above example, when an invoice was created for the month of Jun 2011, the Period showed as “Jun:2011 ends 30/7/11” instead of “Jun:2011 ends 30/06/11”.

This data file was NOT corrupted.

The problem was due to when the user was creating a new period; he/she accidentally entered the last day of period as 30/7/2011 instead of 30/06/2011 (usually last day of the month is automatically used as the last day of the period, however, this user had accidentally amended it manually). 

To resolve the issue, you can:

1. Backup your data file (if you are in multi-user mode, other users should log out of the data file)
2. Go to the Command menu and select Open/Close Period.

 

Click the icon before the Last day of Period and follow by changing the date from 30/07/2011 to 30/06/2011 (as according to your last day of period). Then, click the “Done” button to save your setting.

Now, you can try creating a transaction (such as Sales Invoice), the Period will be shown correctly.

 

Deleting an invoice that was processed from Sales Order

Software: MoneyWorks accounting software

Sometime, we processed the Sales Order to Invoice, and realized that we made a mistake after we had posted the processed invoice. Although we may cancel this processed invoice (Posted), the Sales Order’s  “Ship Quantity” and “Backorder Quantity” do not revert accordingly.

How to amend the Sales Order after processed invoice was cancelled?

Scenario ONE: Short deliver

Assuming the Sales Order’s order quantity is 100 pcs and you processed an invoice with 10 pcs. After posted the invoice, you discovered that you should process 20 instead of 10 pcs.

To resolve this:

1. Cancel your processed invoice, which had a wrongly processed quantity of 10.
2. From Sales Order, process a new invoice (second invoice) with quantity 10. Do NOT post this invoice.
3. Go to the Sales Invoice; amend the quantity of this invoice to 20 pcs. You may post the invoice after amendment.

Now, your Sales Order should have a ship quantity of 20 and backorder quantity of 80. Your total quantity invoiced will be 20.

Scenario TWO: Over deliver

Assuming the Sales Order’s order quantity is 100 pcs and you processed an invoice with 10 pcs. After posting the invoice, you discovered that you should process 3 pcs instead of 10 pcs.

To resolve this:

1. Cancel your processed invoice, which had a wrongly processed quantity of 10.
2. Go to your Sales Order; change the Order quantity from 100 to 110. In this case, the backorder quantity will be back to 100 instead of 90.
3. Add an additional line item in your Sales Order for the item that was wrongly processed. The Order quantity for this item will be -10. Now, the total ordered quantity for this sales order will be back to 100 (110 – 10).
4. Process your Sales Order with the correct quantity of 3.

Assuming now you need to process the remaining 97 pcs. You process your Sales Order as:

Item          Order Qty      Ship Qty        

Item 1             110                     97

Item 1             -10                       0

Leave the ship quantity 0 for the negative order quantity item. Once Sales Order’s backorder quantity is fall below zero, the Sales Order will be closed and transferred to the Sold transaction.

Alternately, you may process every item (including the negative order quantity), but don’t post the invoice during process of Sales Order.  Go back to the processed invoice and remove the additional negative quantity from the invoice.

 

 

Receipts-for-Banking Holding Account

Software: MoneyWorks accounting software

For some businesses, such as retail business, you have lots of cash or credit card payment received daily.

It may not be practical for you to record as deposit for each receipt into the actual bank account, since you will only do a banking-in at the end of the day or once every few days. Hence, Bank Statement will show a lump sum rather than individual transacted amount of the receipt. If every cash receipt were to record into the actual bank account, then, you may have to do a manual calculation to total up the receipts in your MoneyWorks bank account so to check against the actual deposited amount in the Bank Statement during the Bank Reconciliation.

To resolve this, you can set a “suspense” Bank account to temporary hold the cash received and do a banking-in (lump sum) upon actual depositing of cash into the actual bank. In this case, the amount show in the MoneyWorks bank account will be same as the Bank Statement.

How to set a “Suspense” bank account?

From Show menu, select accounts. Then, click the “New” button to add a new bank account (example: Cash in transit, bank account type).

Next, go to the Bank Settings tab of the newly added bank account, example: Cash in transit, select the checkbox for “Receipts-for-Banking Holding Account”.

Reference: Page 38 of MoneyWorks User Guide, Bank Setting – Receipt-for-Banking Holding Account 

Assuming you created a new bank account, Cash in Transit, to receive all the cash from sales. You received two payments from credit customer, S$2,000.00 for payment one and S$3,500.0 for payment two. You deposited these two payments into Cash in Transit account.

The double entry for these two transactions will be:

Debit: Cash in Transit account

Credit: Accounts Receivable

Assuming, on the following day, you deposited the $5,000.00 of the cash received into our Actual Bank and remainder $500.00 will keep it as a Petty Cash.

Reference: Page 105 of MoneyWorks User Guide, The Banking Command

From the Command menu, select Banking. In the Banking Window, select Cash In Transit account from the “Deposit from” drop down list. Highlight the receipt you wanted to deposit, the total amount to be deposit will show in the “Amount Selected” field.

To split your selected amount into two accounts, Petty Cash and Actual Bank, you select the first “Transfer” checkbox and enter [ 500.00 ] into the entry box next to the first “Transfer” checkbox. Next, select the “Petty Cash” account from the “of cash to” drop down list.  In this case, you do not have any Bank Service Charge or Surcharge; so, leave the second checkbox unchecked. MoneyWorks will automatically update the “Net Deposit” to $5,000.00. Simply select your Actual Bank account at the “to”drop down list.

You may consider clicking the “Print” button to print your Deposit Slip. If not, click the Deposit button to save your transaction.

On the next window, MoneyWorks will prompt you to record your Transaction Date, Period, Description, and Analysis information (if any).

This transaction will be recorded as a Journal transaction type (Fund Transfer). The double entry for this transaction will be:

Debit: Actual Bank account

Debit: Petty Cash account

Credit: Cash in Transit account

This method is useful for user who needs to record lots of Cash or Credit Card transactions daily.

Join our training class to have a better understanding on how to apply MoneyWorks accounting software for your business.