Find account information

Fred Office Plus

Fred Office Plus offers a range of reports that allows you to monitor accounts and inform account holders. The reports are under Customer Reports in the System Reports folder.

Account sales

View total sales on a specific account type(s) (Personal, TAC, WorkCover, Other and/or Supplier) over a date range

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select Personal, Supplier, TAC, W/C and/or Other.
4. Ensure Leave Only show Accounts that are Active is selected in the Active Accounts filter.
5. Click Run Report.

6. View the bottom grid line under the Total Sales Inc or Total Sales Ex columns.

   • Total Sales Inc includes Government Recovery including GST. The Sales Inc column does not include Government recovery but includes GST.
   • Total Sales Ex includes Government Recovery but excludes GST. The Sales Ex column does not include Government Recovery and excludes GST.

   Use the Column Chooser to display these columns.

How can I see if a specific sale was made to a specific account in a date range?

1. Go to Contacts, then select Accounts.
2. Search for and open the account card.
3. Go to the Activity tab.

Account usage

Unused credit accounts (Personal, TAC, WorkCover, Other and Supplier)

This report excludes adjustments and payments made through Fred Office Plus.

1. Open the Account List report.
2. Leave the Account Format filter set to Credit.
3. Ensure Only show Accounts that are Active is selected in the Active Accounts filter.
4. Click Run Report.
5. Click on the top right of the column heading Last Visited, and then select Blanks.

When was the last time a credit account (Personal, TAC, WorkCover, Other and Supplier) were used?

This report excludes adjustments and payments made through Fred Office Plus.

1. Open the Account List report.
2. Leave the Account Format filter set to Credit.
3. Ensure Only show Accounts that are Active is selected in the Active Accounts filter.
4. Click Run Report.
5. View Last Visited column.
6. To sort by this column, click the Last Visited column heading.

Account Activity and Cashier Information

Generate a list of all the accounts in a date range with comments

Use this procedure when staff set Comments to specific account sales, payments or adjustments.

1. Open the Account List report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Click Advanced Filters.
5. Enter the comments your staff add into the Activity Comments filter.
6. Click Run Report.
7. Click and drag the Transaction Date column into the column heading.
8. Use Column Chooser to add in Account Comments.
9. Click Account Comments column heading to sort.

View all account activities related to a specific cashier over a date range

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Click Run Report.
5. Click and drag the Transaction Date column into the column heading.
6. Click the Cashier column heading to sort.

View all accounts in a given date range where a return was made

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Click Advanced Filters.
5. Click Activities with Returns (Negative Quantity).
6. Click Run Report.
7. Click and drag the Transaction Date column into the column heading.
8. Click Account Name column heading to sort.

View all accounts in a given date range where a discount was given

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Click Advanced Filters.
5. Click Activities with Discount.
6. Click Run Report.
7. Click and drag the Transaction Date column into the column heading.
8. Click Account Name column heading to sort.

Account Adjustment

Generate a list of all adjustments made to credit accounts over a date range

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Select Adjustments from the Activity Type filter.
5. Click Run Report.
6. Click and drag the Transaction Date column into the column heading.

Find an account I made an adjustment of $20.00 to last month

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Select Adjustments from the Activity Type filter drop-down.
5. Click Run Report.
6. Click and drag the Transaction Date column into the column heading.
7. Click on the top right of the Adjustments column heading and select $20.00.
8. View Account Name column.

Account Payments

View total payments on a specific account type (Personal, TAC, WorkCover, Other and/or Supplier) over a date range

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Click Personal, Supplier, TAC, W/C and/or Other (if applicable).
4. Select the Start and End date from the Transaction Between filter.
5. Click Run Report.
6. View the bottom grid line under the Payments column.

Generate a list of all payments made on credit accounts over a date range

1. Open the Account Activity report.
2. Leave the Account Format filter set to Credit.
3. Select the Start and End date from the Transaction Between filter.
4. Click Run Report.
5. Click and drag the Transaction Date column into the column heading.

6. Click Payments column heading to sort.

   To sort, you can also right-click the Activity Type column heading and select Group By This Column.

Check if a payment has been made to a specific account over a date range

1. Go to Contacts, then select Accounts.

   If using the buttons, the default setting is Charge Open.

2. Search for and open the account.
3. Click Activity.
4. Click the Account Type column heading to sort.
5. View Transaction Date for payments.