Tag Archives: Cloud-Based accounting systems

Work with lists

Transaction list, product list, name list, account list, enquiry list, historical transaction list within an item are lists in MoneyWorks.

List view is like a spreadsheet, with rows and columns of data. You can sort it by clicking on the column header or search the list by entering your request into the search bar on the top right corner. That’s how MoneyWorks presented the information. Simple and easy.

Customise list

Exchange rate
add an exchange rate field to the list

You can customise the list view, add or remove columns according to your preference. The receivable list, for example, shows the outstanding invoices with transaction currency by default. You can add an exchange rate column to show the rate used for the invoice by customising the list view (got to the Edit menu and follow by Customise List View). From the List View Option windows, highlight the ExchangeRate field from the available field window on the left and click the >Move> button to move it across to the Fields to be Displayed in this List window (on the right).

That’s it! The exchange rate column added to the receivable list.

Heading Field

heading field
add a heading field to the list

The heading is a customisable field available in the list view options window. You can use it to pick up data fields from another table, such as lookup for the category or country field of the name table from sales transaction list. Or you may add a formula (Gross-AmtPaid)/ExchangeRate into the heading field to get the home currency equivalent outstanding amount of the receivable.

fields added to the list
Data field added to the list

MoneyWorks is a powerful small business accounting system, available on both desktop and cloud-based. Sign up a free product demo or download a trial to test drive to find out more.

Shall I be using class or location in QBO (QuickBooks Online)?

Class is a powerful feature available in QuickBooks Online (QBO). Although originated from QuickBooks Desktop accounting system, there is a slight difference in reporting.

How to use class in QuickBooks?

You may use the class as a departmental account. Set up marketing, R&D, production, etc. as a class; then, tag it to each income or expense account when creating an invoice or bill. The profit and loss report shows the income and expense breakdown by class once the transaction saved. QuickBooks class feature is a unique way of analysing the business account and less tedious in setting up compared to the sub-ledger method used by other accounting systems.

There are many other ways of using the class feature in QuickBooks:

  • A Law firm uses the class to allocate income and expense of each lawyer.
  • Use it to track the running cost of the sales team or vehicle.
  • Property management business uses the class feature to analyse the profitability of each property.
  • Or you may use the class to track local and overseas sales.

The class feature is flexible and is up to your imagination to apply it into your business account.

QBO class or location?
Location tag to header, whereas the class tag to detail.

Each transaction consists of a header and a detail section. For payment transaction, the payee and bank are part of the header section, whereas the accounts used at the bottom of the transaction are the detail section. Each of the expense account at the detail tagged to a class, and pick up by the Profit & Loss by Class report once transaction saved. But if you print the Balance Sheet by Class from QuickBooks Online, the amount paid from the bank account will group under the unassigned classification since there is no class field available at the header. 

QuickBooks Profit and Loss by Class report
QuickBooks Profit & Loss by Class

You may consider using a location feature, for branches or retail outlets, in QuickBooks Online instead of a class. The data entered will show in both Profit & Loss and Balance Sheet.

QuickBooks Profit and Loss by Location report
QuickBooks Profit and Loss by Location

The location field is at the transaction header section, which breaks down the accounts used in both the header and detail section. Location is a better choice for businesses that have multiple branches, but you cannot have multiple locations in one transaction (at this moment). You may have to get the supplier to change the way they bill or change the internal workflow if they bill you more than one branch in a single invoice.

QBO Balance Sheet by Location
QuickBooks Balance Sheet by Location

Technology is evolving, QuickBooks introduces new feature from time to time. Who knows? Maybe someday there might be a better way of using or reporting by class and location 🙂

Discuss with your QuickBooks consultant, sign up a demo or trial to test drive before you switch over from QuickBooks Desktop to QuickBooks Online.

Page numbering

Software: MoneyWorks accounting software

The Page is a page numbering field in MoneyWorks form designer which you can insert into the form (template) such as invoice or purchase order.

Page numbering is a sequential number applied on a document (or book).

Add a calculation box into the template, then add the page field into the calculation box, check the Always Calculate checkbox to allow the system to calculate and print the page number accordingly.

Page

Refer to the User Guide, Form Designer, to find out more about designing a form.