RQ Money

EXCELLENT SOFTWARE THAT SUITS TO YOUR MONEY

DATABASE

CREATE A NEW DATABASE (CTRL + N)

To get started with the program, first create a new database to store your data. To do so, select CREATE from the Database menu and a dialog box appears where you can specify:
  • name of the file (e.g. MY ACCOUNT). This entry is required. If you do not specify a file extension, the default .RQM will be added automatically. This entry is required.
  • the path directory, where you want the new file store (eg. D:\RQMONEY). This entry is required.
  • currency, in which your account is maintained (minimum one is required)
  • a password, to protect your sensitive data within the file. This entry is not required, just recommended. If you want, you can set the password later.
Upon completion of the above, you will then be informed If the new database is successfully established. You then have two ways you enter your financial transactions within the new database file.
  • Add some data to the persons, accounts and categories lists. This will make adding transactions easier through use of field drop down boxes.
  • b) Or, you can just start to add new transaction. In this case you will have to branch out of the "new transaction form" every time you want to enter, say a new Payee name.

OPEN AN EXISTING DATABASE (CTRL + O)

You can open an existing database by using the dialog box. In the event that you want to open the database from version 2.0, select the file with an extension of RQM. If you want to open an older database (versions 1.3 and lower), select the file with a DB (you must change [file type] in the dialog box). Subsequently, following the confirmation of a file, you will receive instruction that helps you to convert your an older database to the newer version of the 2.0 (Note the original database DB yet does not change).

CLOSE AN OPENED DATABASE (CTRL + X)

This feature is available only if you have opened a database. Closing the database causes all data from the screen to disappear. Subsequently, you can either:
  • create a completely new database,
  • open an existing database,
  • or exit the program.

DATABASE PASSWORD (CTRL + W)

Protection of your financial data is very important. Therefore each RQMoney database file can be protected with a unique Password. To do so, select Password from the Database menu and in the Password Form, type in the new password, confirm it, and then press [Enter] to save it.
Thereafter, any time you want to open that database, the program you ask you to enter the password.
To remove the protection, you can cancel the password using the Change Password Form. Just fill in the old password and leave the new password field blank.

BEGINNER'S GUIDE (CTRL + G)

Beginner's guide is very helpful to starting users. It is offered after successful creating of new database. Sprievodca začiatočníka je pomocný program pre začínajúcich užívateľov. Ponúkne sa po úspešnom vytvorení novej databázy. At each step explains how to fill the lists of persons, accounts and categories (or subcategories), as well as add your first transaction (income, outgoing or transfer) in the main window. You can run beginner's guide in the program whenever is open any database (due to registration records).

SQLITE ZONE (CTRL + Q)

SQLite zone is used for more advanced users for its own operations with a database. This feature has already builte some SQL commands, but the user can enter their own SQL commands to obtain any data (SELECT command), respectively completely change records (INSERT, UPDATE, or DELETE commands).
NOTE: Each user should have prior work in SQLite zone do backup your database! User with incorrect SQL command can damage their data. Therefore, they should perform SQL queries only experienced users who know what each commands mean. Author is not responsible for any damage to the user database.

DATABASE PROPERTIES (CTRL + R)

Clicking PROPERTIES from the Database menu, allows you to view a dialog showing the current properties of your database file (eg name, size, date of last changes, etc) and about counts of records in database tables.

TRANSACTIONS

A financial transaction can be any of three types (Income, Expenditures or a Transfer). An income or expenditure transaction adds one record to the database. A transfer AUTOMATICALLY results in two records, a debit from the donor account and a credit to the receiving account.

ADD A NEW TRANSACTION (INSERT)

Clicking on the Add transaction toolbar icon brings up the New Transaction Form where you must complete the five mandatory fields (Transaction Date, Transaction Type (direct debit, credit, transfer) ACCOUNT, CATEGORY and a PERSON. The AMOUNT, DESCRIPTION and PAYEE fields are usually needed but not mandatory.
In the AMOUNT field, you can perform simple calculations (without brackets [] or parenthesis () in the enumeration) for a transaction composed of several items. Only additions and subtractions (to version 2.1.0), divisions and multuplications (from version 2.1.0) operation are allowed, eg:

  • 132,5+44-19,6 (there appears a result 156.90 after pressing Enter) or
  • 2,5+3*4 or
  • 12*10/2,5 or
  • 25,4-33/3,3
You can move between the New transaction Form Fields by pressing ENTER (recommended) or by tabbing if you are not changing the field data.

CHOOSE FROM LIST
If, as recommended, the field lists are populated with data, you can easily select say the Payee data using that field dropdown box. To do so either:
  • type the first letter of the Payee and then use the down/up arrows to select the desired PAYEE,
  • use the mouse to open the Payee field dropdown list and choose the item by dragging down,
  • using the keyboard shortcut ALT + down arrow,
If desired Payee is not in the Payee list, click Payee icon to bring up the add Payee form and complete it before proceeding.

When all necessary fields are completed, save the new record by pressing ENTER. The new record will displays in the main window.
You can click on any of the Transaction Table column headings to sort the transactions in ascending or descending order.

EDITING OR CORRECTING TRANSACTIONS (ENTER)

Any entered transactions can be edited using the Toolbar Edit Icon, or by double clicking the record to bring up the transaction form. In the form just overwrite any of the text fields (DATE, AMOUNT, DESCRIPTION) or select a different value from the field dropdown boxes (ACCOUNT, SUBCATEGORY, PERSON or PAYEE). Click to button SAVE or shortly press SHIFT+ENTER to resave the edited record.

COPY THE TRANSACTION (CTRL + INSERT)

Income or Expenditure records previously entered can be copied (duplicated) using the Transaction copy Icon. This creates a completely new record but with the same data values. You can then edit if needed.
You can only copy INCOMING or OUTGOING type of transaction (NOT TRANSFERING).

DELETING TRANSACTIONS (DELETE)

For a single record deletion, click to highlight that record and the click on the Delete Transaction Icon on the Toolbar to remove that transaction.
Similarly for multiple record deletion you can highlight the records in several ways:
  • To delete a continuous block of records, highlight the first record, press SHIFT and drag to select the last record.
  • If the records are separate rows, press CTRL and the click the mouse on each record you want to mark for deletion
  • and for a TRANSFER deletion it is necessary to mark and delete both the transfer records
IMPORTANT NOTE!!!
After deletion of a record is not possible to undo that action. All of the transaction steps that you perform on the database (adding, correcting, erasing) are carried out and stored instantly, it is not necessary to save the database file later. The great advantage of this system is that, in the case of a power or operating system failure, all your work is stored. The downside is, if mistakenly delete or overwrite some records-it is not possible to step back!!!
Therefore, the author recommends that you BACK UP the database whenever the program is used (or archived). This is easy as Version 2.0.x and later of RQMoney automatically backups the database on exiting the program. (This feature is free for databases with less than 2000 records). If the user exceeds 2000 transactions the database automatic backup is disabled. However, a contribution of 10 € to the author for further development of the program will give you a license key that will unlock the automatic backup of all databases on that computer. For more detailed information about the license key, visit the donation page.
AUTHOR IS NOT RESPONSIBLE FOR ANY DAMAGES YOU USE THIS PROGRAM !!!.

TRANSACTIONS IMPORT (CTRL + I)

Program allows to import CSV or TXT files (eg. bank statements) to get their transactions to the program.
On start you need to choose:
  • the file for the import (CSV or TXT format)
  • the target account and
  • the correct template to specify import formats of the date, the amount, the type of transactons, etc. No one template is prepared for the user, he needs to set his each template himself and save it for the future using.

TRANSACTIONS EXPORT (CTRL + E)

Program allows to export selected transactions (also Summary table, Statistics or SummaryX data) to the various formats like PDF, CSV or XLS to another use. User can set many other printing options for PDF page (paper size and orientation, font, margins, etc) or some format options for XLS page.

TRANSACTIONS HISTORY (CTRL + H)

This informative function works from version 2.4.0 only.
Transactions created in lower versions have missing date of creation.

LISTS

PERSONS (F12)

A required Transaction field with no limit to the number of persons on the list. This list records the names of all the individuals who use the database. A listed Person must be assigned to each new Transaction.
WARNING: Deleting a person from the list also deletes all transactions (revenue, expenditure and transfer), which were assigned in the database to that person.

CATEGORIES (F11)

A required transaction field with no limit to the number of categories/subcategories on the list.
The Category field dropdown box facilitates the entry of revenue and expenditure transactions by category. If, for example. you use a car, just create a category names "car" and the relevant subcategories (eg. petrol, servicing and repair, insurance, etc.).The order of sorting records in the box is the following.:
THE ORDER-THE MOVEMENT-CATEGORY-SUBCATEGORY.
The order is used for prioritize the most frequently used entries on top. If you leave the order everywhere the same, it will be shifting records alphabetically ... (thus the first MOVEMENT, then the CATEGORY and at the end of SUBCATEGORY). It is up to you how much detail you assign to your category and the subcategories.
WARNING: Deleting the category will delete all the transactions (revenue, expenditure and movements), which are in the database assigned to it.

ACCOUNTS (F10)

A required transaction field with no limit to number of accounts on the list. This List records all the accounts covered by the database. Each account can be of any currency but it is not possible to have multiple currencies in one account.
At the start of a new database you should assign a minimum of 2 accounts (eg. Cash and a BANK ACCOUNT). You can specify the opening balance of the account. The Date of establishment of the account is required to check against the date of the Transaction entry. The program will not allow the writing of transaction (income, expenditure or movement), where that date is older than the date of establishment of the account.
WARNING: Deleting the account will delete all the transactions (revenue, expenditure and movements), which are in the database assigned to it.

DESCRIPTIONS (F9)

The is an optional field in a transaction with no limit on number of descriptions in the list. The list is used for faster data entry of repetitive transaction descriptions or memos .(e.g. rent for an apartment, instalment credit, selecting from an ATM, etc.).

PAYEES (F8)

The data is required in a transaction and there are no limits to number of Payees on the list. The List assigns a PAYEE name to the transaction. Typically the recipient of the financial transaction.
WARNING: Deleting a Payee also deletes all transactions (revenue, expenditure and movements), assigned to that Payee in the specific database.

CURRENCIES (F7)

The list is used in conjunction with an account. Each account must and can have only one currency. The user makes his own currency list either by selecting from the currencies given or by adding another one in the Add Currency Form.
For each currency there is sub list of all the notes and coins. As long as they are entered in the register, it is possible to easily count your cash in that currency by using the Cash Counter feature.
Note: It is possible to DELETE a currency only if it is not used in any account. In the event that you have established an account in that currency, the currency cannot be deleted.

NOTES (F6)

The number of notes in the list is unlimited.
This list allows the user to call up Notes that have no connection with the data in the database. The program allows notes about the consumption of water, gas, electricity, gasoline and fuelling operations, etc. Since version 2.0 the ability to insert notes with arbitrary name and frequency is allowed.

NATIONAL HOLIDAYS (F5)

The number of public holidays in the list is unlimited.
A list of the public holidays in the user's country. Used when generating scheduled payments (monthly, quarterly, semiannual and annual only). In the event that the date of the planned payment lands on a public holiday, the actual scheduled payment date becomes the day before.

EXTERNAL LINKS (F4)

The number of notes in the list is unlimited.
The list is used to register internet links, which will serve the user eg. for a quick connection to the bank (eg for account statements), the central national bank (due to exchange rate difference), but the user can put any links to favorite sites there. The advantage is usage of own keyboard shortcuts so after pressing them, the user automatically opens the web browser with the page.

FINANCIAL TOOLS

PERIODIC TRANSACTION SCHEDULING AND REMINDERS (CTRL + S)

Use the Scheduler Form to plan periodic transactions (revenue, expenditure or transfers) or to remind you to enter an important one time transaction. To do so, click on the "Show Schedular" Icon on the toolbar to bring up the Scheduling Form, click Add and then pre enter the transaction's details and it's periodicity. This form contains two extra fields:
1. Interval: You can choose from the following:
  • daily
  • weekly
  • biweekly (every two weeks)
  • monthly
  • quarterly
  • half-yearly
  • annually
  • one time payment
2. Duration: Enter the "actual" date of the first transaction in the "From" Date but the "To" date can be actual or slightly later than the schedule's end. Opening the program on or after the scheduled dates causes the transactions reminder to display on the "start up" screen. Now you can "write" the displayed transactions to the register.

ADD THE SCHEDULED PAYMENTS (INSERT)
o Add a new scheduled payment, enter the Scheduler form and fill in all normal transaction fields and the periodic "intervals" and schedule "duration". The program then generates and displays all the planned transactions on the right hand side of the form. There you can add, correct, or delete, any of the generated transactions.
You can also convert any "entered" transaction to a "recurring" one by right clicking on the transaction then selecting "set as a new scheduled item" from the resultant context menu.

EDITING SCHEDULED PAYMENTS (ENTER)
Open the "Transaction writing" form and select those to be immediately edited / registered. During writing the scheduled transaction most but not all fields are editable. It is not possible to correct the periodicity interval and the from-to Duration dates. If you change the amount, it will automatically be changed for that transaction's remaining future entries.
If and when you want to extend the duration of a scheduled transaction item, right click on that item to bring up the "scheduled payments list", select "Add" and enter the desired new "end date".

DELETE THE SCHEDULED PAYMENT (DELETE)
The scheduler module stores all the generated transactions. If you need to delete some but not all, open the list of generated transactions and delete only those required.

IMPORTANT NOTE!!!
After editing or deletion of the scheduled records it is not possible to undo these steps. Deletion of an item from the schedule list will not effect its previously written transactions.
The author is not responsible for eventual damage of the database!!!

PLANNING CALENDAR (CTRL + D)

Planning calendar offers a transparent way to view all the planned transactions. In the calendar settings, you can select the period (month and year), for the planned transactions. In the day windows are separately summaries for the revenue, expenditure and transfers. If you want to see details about each day's summary hover the mouse cursor over a specific date and a detailed list of all the payments for that day will show.

WRITING (REGISTERING) SCHEDULED (CTRL + Y)

Whenever you open a database, the program checks whether there are any transactions planned for today's date or earlier planned transactions that have not yet been written to the Register. If any are found, it will display these transactions. You can then choose whether to write all or just some by unchecking those you do not want to write. Those remaining will remind you every time the database id opened, unless either written or deleted.
Before writing you can edit the date or amount fields of a scheduled transaction.

In the program Settings, you can set the "Show scheduled Transactions for the Next X weeks. Setting this to eg. 6 weeks causes the reminder to include all scheduled transactions for the next 6 weeks. If you chose to write them you can view your account balances up to six weeks ahead.

THE BUDGET (CTRL + B)

The monthly budget feature is very helpful to those who plan their revenue or expenses, and later compare the actuals. Comparative data (plan and actuals) are then evaluated both in numerical form (differences, the percentage), both also in graphical form.
You can export the Budget data to the Clipboard, PDF, Spreadsheet (.XLS) or .CVS file and Copy or Save the chart.

ADDITION A NEW BUDGET (INSERT)
A dialog box appears with a list of categories and subcategories, which you can include in the monthly budget. Just select the row (subcategory of) and type in the scheduled amount. You can include a category with zero amount planned but that category must be checked off. At the end of the input and close the form, a dialog appears, in which you specify whether you want to write all values to the database or not.
Watch out, it is not possible to add a budget for a month, which is already there!

EDIT/FIX BUDGET (ENTER)
Within the existing budget you can edit any item except the name of the budget (the month). After you close the window, the program asks you to save the data to the database.

COPY A BUDGET (CTRL + INSERT)
Select Copy from the Budget form and just change the month. After you close the window, the program asks you to save the data to the database.

DELETE BUDGET (DELETE)
If you delete a monthly budget, you delete all planned data in this month. Also in the budget of the following applies:

IMPORTANT NOTE!!!
After carrying out the repairs or the deletion of the record is not possible to undo these steps back.
The author is not responsible for eventual damage of this program!

CASH COUNTER (CTRL + U)

If you need to calculate your cash, this function is just for such purposes. Just select a specific menu, and then you write down the values of the individual quantities. The resulting summary cash appears in the first line.

WINDOWS CALCULATOR (CTRL + K)

In the event that you need to perform some calculations, you can start the Windows calculator. Works only on Windows platform (not Linux, MacOS, ...).

VIEW

SWITCHING 3 BASIC WINDOWS

Main window provides 3 basic subwindows to the user:

Window TRANSACTIONS (CTRL + ALT + T)
It is the basic window of the program. It displays registered transaction (credits, debits and transfers). It also allows:
  • view of all or selected transactions (according to the FILTER in the side panel)
  • sort of transactions (by click to the column header)
  • summary of displayd transactions (by accounts or by lists - persons, categories, subcategories, currencies, payees)
  • view of summary data in the chart (various types of the chart)

Window STATISTICS (CTRL + ALT + S)
This windows informs the user about main summaries according to the selection criteria of the Filter, also in the chart view. Part of this statistics is a timeline of transactions (you can set different time limits for statistical sampling).

Okno SUMMARY X (CTRL + ALT + X)
Also this window serves for the Statistics outputs. It displays the main summaries in (so-called) cross forms according to the choosen lists (something like Cross-tables in the MS Excel). Eg. the user can choose to display summaries of all users, how much they spent for various categories, or which account was used for various payees. It depend on the user only, which form he want to display in (numerical or graphical form).

DISPLAY PANELS

Hide/display of some of the panels of the main screen is used mainly for users with a smaller monitor. The recommended screen resolution is 800 x 1200 px, but in the case of a smaller width of the monitor will provide just temporary hiding of one of the panels:

Panel FILTER (CTRL + ALT + F)
The FILTER is located in the left side of the main screen. Using it, you can filter records (for different time periods, currencies, accounts, transaction types, categories, subcategories, people, payees, description or amount). Hiding (or display) will increase (or decrease) available screen space for the display of the Transactions Register..

The TOOLS Panel (CTRL + ALT + L)
The TOOLS Panel contains all of the main icons of the program. Through them you have quick access to all of the features of the program. Hiding (or display) increases (or decreases) the space for the display of the transaction Register.

SUMMARIES AND CHARTS (CTRL + ALT + M)
This panel is displayed at the bottom of the main screen (along with the chart). It displays user-friendly summaries of accounts (initial balance, Income/Expense and final balance, as well as detailed summaries of transactions (income, expenditure and transfers of each of the categories, subcategories, persons, accounts, currencies and payees. Hiding (or display) will increase (or decrease) of space for the display of the transaction register.

ARRANGE PANELS

The user can set (according to the monitor size) the Panel SUMMARY AND CHART postion. This Panel can be arranged and switched as Horizontaly (CTRL + ALT + H) or Verticaly (CTRL + ALT + V).

PROGRAM

PROGRAM SETTINGS (CTRL + T)

User can set several items of PROGRAM SETTINGS, which are grouped by common attributes into many groups:
  • language settings,
  • actions on starting program,
  • actions on exiting program,
  • toolbar settings,
  • formats (dates, numbers, ...),
  • forms settings (scheduler, calendar, payments, SQLite zone, ...),
  • charts settings,
  • importand backup settings of database,
  • confirming of some importand actions (program exiting, records deleting),
  • export to PDF, XLS or CSV formats
  • etc ...

ONLINE MANUAL (F1)

You will see the following pages: Database, Transactions, Lists,Financial Tools, Program, Shortcuts
It is recommended to use the latest versions of internet browsers due to newest CSS3 standards used in these HTML pages.

CHECK THE NEW VERSION OF PROGRAM (CTRL + F1)

The user can manually check at any time to see if he has the latest version of the program. This can also be done automatically as described above using PROGRAM/SETTINGS menu.

ABOUT PROGRAM (SHIFT + F1)

The user can see the program details (name, version, license, date of issue), as well as about the author truncated data and contact information.

EXITING THE PROGRAM (ESC)

User can set up (in the menu DATABASE / OPTIONS) the confirmation before exiting the program. The program automatically closes the database connection.

SHORTCUTS

KEYACTION
F1Online manual
F2-
F3-
F4-
F5List of Public holidays
F6List of notes
F7List of currencies
F8List of payees
F9List of descriptions
F10List of accounts
F11List of categories and subcategories
F12List of persons
Pause/breakCancel all filters
Ctrl+F1Check new version
Shift+F1About program
EscExit program
InsertAdd record
EnterEdit record
DeleteDelete record
Ctrl+InsertCopy record
Ctrl+ASelect All records
Ctrl+BBudget
Ctrl+CCopy all records
Ctrl+DCalendar of scheduled payments
Ctrl+EExport to CSV/XLS/PDF file
Ctrl+GBegginner's guide
Ctrl+HHistory of the transactions
Ctrl+IImport from CSV/TXT file
Ctrl+J-
Ctrl+KWindows Calc
Ctrl+L-
Ctrl+M-
Ctrl+NCreate New database
Ctrl+OOpen existing database
Ctrl+PPrint filtered records (into PDF file)
Ctrl+QSQlite zone
Ctrl+RDatabase properties
Ctrl+SSScheduler
Ctrl+TOptions
Ctrl+UCash counter
Ctrl+V-
Ctrl+WChange database password
Ctrl+XClose opened database
Ctrl+YWrite scheduled payments
Ctrl+Z-
Ctrl+Alt+TShow module Transactions
Ctrl+Alt+SShow module Statistics
Ctrl+Alt+XShow module Summary X
Ctrl+Alt+FHide / Show pane Filter
Ctrl+Alt+LHide / Show pane Toolbar
Ctrl+Alt+MHide / Show pane Summary (with chart)
Ctrl+Alt+HArrange panel Summary horizontal
Ctrl+Alt+VArrange panel Summary vertical