Wild-Card Characters in Account Numbers

Note that Financial Reporter allows you to use two wild-card characters when specifying account numbers:

_ (the underline character, which is a place holder for one character)

% (percent character)

The underline and percent characters are place holders for one or more characters.

For example, D_6834 specifies all single segment accounts sharing the same first character (D), followed by one character of any value, and ending with the same four characters (6834).

FR Paste does not support wildcard characters with the Finder. You must type in the wildcard characters yourself.

"%%" is not a wild-card character

Although "%%" resembles a wild-card character, it is used in only two very specific ways:

%% specifies all account numbers in the ledger. (See the "QUIKINC" and "QUIKBAL" statements that come with General Ledger.)

6000%% specifies all account numbers starting with 6000 — no matter how many segments they have. (This specification has the same effect as 6000:6000.)

In the following spreadsheet example, the account number selection is based solely on the account group specified in column B. The Financial Reporter will list all Current assets, then all Fixed assets, and, finally, all Other assets.

Note: Using "%%" will not be very efficient if the Financial Reporter is forced to process every account in the ledger to see if it fits the criterion in column B. The above report should specify account group order.

Don't mix account ranges and wild cards

Note also that you cannot combine account reference ranges with wild-card characters. For example:

A123%:B567% is not allowed.

However, you can combine account references in a list (as shown below).

1000:1099, 1100~1199-B, 1250-A

See also

Account Ordering, Processing Order, and Account Segment Ranges

Specifying Account Numbers in Formulas and Rows