Category Archives: Accounting

Import journals into accounting software

Software: MoneyWorks accounting software

You need to have type, date, reference, account, description, and amount field in the spreadsheet when preparing an import file for journal transaction.

For journal transaction, use “Jn” for type field. You can either have the type field in the spreadsheet or preset it in the import MAP. The Date is the date of the journal transaction, which you can either have it in the import file or set it in the import MAP as the date of import.

The account field captured the account code, which has to be the same code you used in MoneyWorks. You do not need to have the account name as it will pick up from the system automatically. The journal memo map to the description field of the detail line and the amount field contains both debit and credit value (with a negative for credit).

Import Journal into accounting software

Import the file from the File menu once you have prepared the spreadsheet. Alternatively, you can save the import MAP if you require to import frequently.

Besides importing journals, you can also import transaction such as Invoices, order, payment or receipt transactions. MoneyWorks is a powerful system which helps an accountant ease the daily accounting task. Book a demo today to find out more about how MoneyWorks helps in managing your business finance.

The Create Journal

Software: MoneyWorks accounting software

Create Journal is a stock related journal in MoneyWorks accounting system, which uses to increase the stock quantity such as manufactured or the existing product. For example, you discovered that Product_123 has ten pieces instead of nine, you may use a Create Journal to increase the stock on hand of Product_123 instead of a full stocktake process. Use a relevant Cost of Sales or Expense account as a contra account if you are using a Create Journal instead of inventory assembly feature to increase the stock on hand of the manufactured product.

Create journal

Change the contra account to SETUP if you are using the Create Journal instead of a stocktake to record the ‘opening stock’. The SETUP account is an account used in MoneyWorks to store all the opening balances of your file.

MoneyWorks is a powerful accounting system at an affordable price. Download a trial to test drive or sign up a free demo to find out how MoneyWorks works for your business.

 

 

QuickBooks Chart of Accounts

Software: QuickBooks Desktop Accounting Software

The Chart of Accounts in an accounting system is a list of accounts, which categorised into Incomes, Cost of Sales, and Expenses to form the Profit and Loss statement; and Assets, Liabilities, and Equities of the Balance Sheet.

The Accountant has to create the chart according to the organisation requirement and comply with the accounting standard.

QuickBooks Account

The Chart of Accounts is under the Lists menu of the QuickBooks Desktop accounting software. Click the Account button at the bottom of the list window to add, edit, or delete an account. You can also use the ‘Subaccount of’ feature to group accounts; for example, you can group Basic Salary, Bonus, Overtime Pay, and CPF to the Payroll expense account. This ‘subaccount of’ feature allows you to expand or collapse the accounts within the Profit & Loss or Balance Sheet report.

Expand view:

Payroll
– Basic Salary 10,000
– Bonus 5,000
– Overtime Pay 3,000
– CPF 3,600

 

Collapse view:

Payroll 21,600

For those who prefer to work with an account number, it can be turned on from the Preferences (under the Edit menu). QuickBooks account number support up to 7 characters, which should be sufficient for most of the small businesses. However, you should not use account number feature if your computer has turned on non-English languages such as Chinese, Japanese, Thai, etc. For example, a ‘?’ will be inserted between the account number and account name, and cause an error when the Chinese language has turned on.

Consult your accountant if you have a problem in organising the Chart of Accounts.

Sign up a free QuickBooks demo to find out more on how to use QuickBooks to manage your business finance.