How to run simple sales reports from the Transaction Lists?

How do I run a report for a certain customer over time? And sort by highest sales to lowest sales within that same report?

In answer to your first question, a report for a certain customer you can isolate the individual customer or selection of customers s follows:

Go to Show menu Names and the Names list {Red Arrow] opens. Highlight the name [Green Arrow], Go to Reports menu [Black Arrow}, Sales folder [Purple} and select the Customer Sales Report you want e.g. Customer Sales over time.

Continue reading

Chart of Accounts: Using Categories

Q: I am taking care in setting up my chart of accounts, using MoneyWorks Cashbook on a my Mac and wanted to know how to use categories?

About the Chart of Accounts

All versions of MoneyWorks (Cashbook, Express & Gold) contain a fully integrated General Ledger and standardized chart of accounts. The chart of accounts templates (e.g. General Business etc.) are presented with the account types sequentially numbered in North American standards (e.g. GIFI in Canada. GAAP in the USA).

Of course the numbered codes (e.g. 7 alphanumeric characters) and the descriptions (e.g. 39 alphanumeric characters) can be changed to best represent and record the details that you want to or are required to track in your business (see TIPS article: modifying your chart of accounts).

Additionally MoneyWorks Gold consists of a departmentalized general ledger, meaning that you can set up departments and/or cost centers that allow you to track and report on individual business units e.g. locations, fleet of vehicles, departmentalized personal etc, See Tips article: How Departments work n MoneyWorks Gold.

Categorizing your Chart of Accounts

Alternatively to departmentalized or cost center accounting, many businesses categorize their accounts so that they can report and analyze their business results (e.g. Balance Sheet, Income Statement or P&L) in differing formats. Although they may possibly want to record their expenses, income, assets etc. into very detailed accounts for governmental or other financial considerations, when reviewing their results each month they are more concerned about how much was expensed by category or type of expense, e.g. all vehicle expenses as opposed to individual expenses for each vehicle or all communication charges versus each cell phone, land line, fax and internet connection. Continue reading

Charging Interest on overdue invoices script

The latest MoneyWorks 6.0.6 update, introduces a new concept of running a MoneyWorks Report as a script.

Basically a Report Script consists of a MoneyWorks custom report that, instead of being installed in the Custom Reports folder, is installed in the Custom Scripts folder. Such a report will appear as an additional command at the bottom of the Command menu.

You can do a lot with a Report Script that you had to previously use something like vbScript (Windows) or AppleScript (Mac), and of course the scripts are platform independent. For example, a Report Script can read a text file, massage it in some way, and then bring the data into your MoneyWorks file as a set of transactions (or customers, jobs etc).

As an example, engineering has created an “Apply Interest” Report Script, which takes the overdue balances in your receivables (either 30+, 60+ or 90+), calculates the interest on these (at a whatever rate you decide), and then optionally creates invoices to charge the overdue customers. Continue reading

How do I adjust the fonts and layouts in reports

Q: My accountant wants a print out of all the transactions for last year. As recommended I choose the Ledger Report, but there are many lines on the report is too tight for him to clearly see. I can adjust the print size, but how is their a way to add spaces between the lines?

MoneyWorks allows you to choose the font that your want to use for reports and set up the page layout for each of your reports. Here’s how. Continue reading