Software: MoneyWorks accounting software For those who print product labels may sometime need to print the label start from Row number ‘x’ of the Column “y” instead of the default Row 1 of Column 1. To achieve it, you may modify the setting from the print order of the Form... Continue reading

Some user may have an issue with a large TLG file, it may grow up to as huge as 1.7 GB, and this may cause errors or backup to hang. One of the possible causes is the automatic update setting in your Search preferences. To prevent overgrown TGL file, you may disable it. From the Edit menu, go to the Preferences, highlight Search from the left panel and click the Company Preferences tab. In the Company Preferences tab, unchecked the “Update automatically” from the Search Box Preferences. If you are not sure, you should consider engaging a QuickBooks Consultant. Once... Continue reading

Software: QuickBooks Some user may have an issue with a large TLG file, it may grow up to as huge as 1.7 GB, and this may cause errors or backup to hang. One of the possible causes is the automatic update setting in your Search preferences. To prevent overgrown TGL... Continue reading

Software: Reckon QuickBooks (Reckon Accounts) For those users who upgraded their Reckon QuickBooks (especially upgraded from version 2011/12) to version 2012/13 or Reckon Account 2013 may have an error on those Home Currency Adjustment journals, which they had entered in the previous version of Reckon QuickBooks. Assuming your Base Currency is SGD and you did a home currency adjustment in your earlier version of Reckon QuickBooks for SGD 100.50 gain for your USD Customer. The double entry for this Home Currency Adjustment journal will be: Account Debit Credit USD Accounts Receivable 100.50 Exchange Gain/Loss – Unrealised 100.50 This is a... Continue reading

Software: Reckon QuickBooks (Reckon Accounts) For those users who upgraded their Reckon QuickBooks (especially upgraded from version 2011/12) to version 2012/13 or Reckon Account 2013 may have an error on those Home Currency Adjustment journals, which they had entered in the previous version of Reckon QuickBooks. Assuming your Base Currency... Continue reading

Software: MoneyWorks accounting software You may need to restore a backup file when you suspected that there are entry errors in your current file. You may want to start using the backup file and re-enter the transactions again or simply compare the reports between the current working file and the... Continue reading

Software: Intuit QuickBooks 2013 One of the changes in Intuit QuickBooks 2013 is the Discount & Credit feature in the Customer Payment window. In the previous version, there is a Discount & Credit button at the bottom of the Customer Payment window, now it has changed to a radio button “WRITE OFF THE EXTRA AMOUNT”. Assuming you apply a payment of 1,050.00 with a bank charge of 20.00 to an invoice of 1,070.00. In the Customer Payment window, enter the amount as 1,050.00 and select your invoice for the amount due of 1,070.00. Then, select the radio button “WRITE OFF... Continue reading

Software: Intuit QuickBooks 2013 One of the changes in Intuit QuickBooks 2013 is the Discount & Credit feature in the Customer Payment window. In the previous version, there is a Discount & Credit button at the bottom of the Customer Payment window, now it has changed to a radio button... Continue reading

Software: MoneyWorks accounting software Assuming you run a hardware shop selling screw, bolt and nut. As a retailer, you will usually buy goods in a box or carton form and repack it into a smaller unit such as bag or packet form. How to record this in MoneyWorks? How does... Continue reading

Software: MoneyWorks accounting software Assuming your financial year is from January to December; and you wanted to start recording your account into MoneyWorks from year 2012. In the setting up new company wizard, Period setting, Set “Financial Year” to “Jan-Dec” and select “2012” in the “Start in” field. In the... Continue reading

Software: MoneyWorks accounting software When recording a Purchase Invoice (Bill) from supplier you got a 1 cent different. Why? This is due to different in method of calculating GST, some accounting software is summing the GST amount for each line item, but some may be using total amount payable (excluding... Continue reading

Software: MoneyWorks accounting software Assuming you did a provision in last financial year for the withholding tax of S$10,000.00 (Singapore dollar is the base currency), at the point of providing the provision you are not sure of the type of currency will be taxed or exact amount. The double entry... Continue reading

Software: MoneyWorks accounting software Received your bank statement for the month of January 2012, it shows a closing balance of $100,500.00. You discovered that you had accidentally recorded a payment transaction, rental expense for the amount of $2,568.00, for the month of January into the month of February. This cheque... Continue reading

Software: MoneyWorks accounting software When ordering large quantity or high value of goods from supplier, often supplier requires you to place a deposit (or advance payment) before goods is being delivered or manufactured. You need to create a non-stock item, Deposit, and associated this item with both Advances to Supplier... Continue reading

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... Continue reading

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... Continue reading

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... Continue reading

Software: MoneyWorks accounting software For those users who use the Purchase Order function in MoneyWorks, can select “Pay Deposit for Order” during process of Purchase Order to pay a deposit (advance payment) to your supplier. As for those users who didn’t use Purchase Order function can consider to use the... Continue reading

Software: QuickBooks Canadian version For Singapore user who uses the QuickBooks Canadian version, you can’t use the Intuit Payroll services (for Canada only). However, if you only have a handful of staffs, you may consider using the Journal method which I mentioned in my earlier blog post or using the... Continue reading

Software: MoneyWorks accounting software Landing cost are the costs incurred in transporting an item from the place of purchase to your premises. These might be including freight, insurance, duties and more. - Page G-248 of MoneyWorks User Guide Landing cost item is not a stock item; hence, if you used... Continue reading

Software: QuickBooks version 2011/12 (Australian) accounting software If you ever try customising your invoice template, you will notice that the order of the “Amount” column is locked. Some user prefers to have the Tax Code column position behind the Amount column; however, they can’t do it. Even if they were... Continue reading

Software: QuickBooks When printing Statement from QuickBooks accounting software, you will notice an “unknown” field show on your statement – Amount Enc. What is Amount Enc.? Frankly, I don’t really know what is “Amount Enc.” either. I couldn’t find any official explanation about “Amount Enc.” from either help file or... Continue reading

Software: MoneyWorks accounting software You can create a memo item in MoneyWorks to capture long project descriptions or shipping details. Simply add an asterisk before your item code (example: *Remarks), and you can hid this Asterisk item from printing at the quantity, Item Code, Price, etc. column of your invoice... Continue reading