Recurring Transactions Table

Documentação •
Neste artigo

The Recurring Transactions table is used to store entries that are used repeatedly.

It contains three types of recurring entries:

Display and arrange columns and views in the Recurring Transactions table

Before inserting repetitive entries, you must display the Recurring Transactions table from the Actions > Recurring Transactions menu.

The Recurring Transactions table does not allow saving custom display settings but inherits views and column settings from the Transactions table.
To customize the columns and their layout in the Recurring Transactions table, you need to:

  • Add a new view in the Transactions table.
  • Arrange the columns setup the Transactions table in the desired order.
  • In the Recurring Transactions table, choose the view that was created (in the Transactions table). The columns will be displayed in the same order as the created view.

Insert recurring transactions using the Doc column

For repetitive operations, you can create codes to insert in the Doc column for automatic data retrieval.

recurring transactions

The Recurring Transactions table in Income and Expense Accounting

The functionality of the Recurring Transactions table is the same as in Double-entry Accounting, only the columns differ:

  • In Income/Expense accounting, the Account and Category columns are used.
    • The Account column refers to the bank, postal, credit card account, etc. It indicates where the money is taken from or where it goes.
    • The Category column indicates the category of the expense or income. It represents the reason for the expenditure or income.
    • The Income and Expenses columns indicate the amount of the transaction.
  • In double-entry accounting, the Debit Account and Credit Account columns and the Amount column are used.

recurring transactions

Sequential numbering of documents "docnum"
If you need a different numbering than the automatic one in the Doc column of the Transactions table, insert a row in the Recurring Transactions table with the code "docnum" in the Doc column. The numbering type specified in the Description column will be used for the following rows.

  • "0" if you don't need automatic numbering.
  • "1" for progressive numbering.
  • "cash-1" for progressive numbering with the "cash-" prefix (cash-2, cash-3).
    The program replaces the number at the end of the text with a progressive number.
  • If you want only one line per code to be displayed in suggestions, precede the description as follows:
    • A "*" – Only this line is displayed and not those with a similar code.
    • A "**" – Only this line is displayed, but it is not retrieved (title line only).
    • A "\*" – Allows the description to start with an asterisk without being interpreted as a command.

Retrieve recurring transactions in the Transactions table

In the Transactions table, you can retrieve the rows defined in the Recurring Transactions table:

  • In the Transactions table, enter the date in the transaction row. You can also add other missing columns compared to those in the Recurring Transactions table, depending on the view you're using.
  • In the Doc column of the Transactions table, select one of the codes defined in the Recurring Transactions table (Doc column) and press Enter:
    • The program inserts the repetitive rows with the same code.
    • If needed, you can always modify or complete some values.
  • Rows stored in the Recurring Transactions table can also be retrieved in the Transactions table by entering the code in the Doc column and pressing the F6 key.

Copy transactions from the Transactions table to the Recurring Transactions table

Repetitive entries can also be inserted by copying entries from the Transactions table and pasting them into the Recurring Transactions table.

Proceed as follows:

You can also use the Ctrl + C and Ctrl + V keys to copy transactions.

 

help_id
accounting::recurringtransactions

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email