Department Budgets

Department Budgets

This module can be used to help with budgeting by Department. You can establish an overall annual budget for each Department. And for every auction set up and assigned to a department, the sale will be added as a budget column. Using the "Budget Setup" worksheet, you can then assign budget line items to each sale, including Income and Expenses.

Departments need to be set-up under Settings/Departments and auctions need to be assigned to a department in order for the budget module to accurately collate the data. 


Budget Setup 

  • Select the department from the list you wish to set up a budget for. Once auctions are assigned to a department, the auctions will appear as columns in the report.
  • In the 1st column for each department you will manually add your "Annual Budget" numbers into the fields. 
  • Certain actual results will be generated by the FWS system when auctions take place (e.g. "Hammer Price", "Negotiated Commission"). Other line items may be imported from other sources like Quickbooks, if your company job-costs and you can map your data to the FWS budget line items (see Budget Import"). In "Line Item Setup", you can generate these additional budget categories to be added to your budget module.

save image

Budget Report

  •  The report (by Department) will show the Annual Budget, the "Expected" and the "Actual" for each auction.

Budget Import

  •  You can import Budget actuals from Quickbooks or other financial data programs as long as the formatting follows certain formatting guidelines.

Line Item Setup

  • Certain actual results will be generated by the FWS system when auctions take place (e.g. "Hammer Price", "Negotiated Commission"). Other line items may be imported from other sources like Quickbooks, if your company job-costs and you can map your data to the FWS budget line items (see Budget Import"). In "Line Item Setup", you can generate these additional budget categories to be added to your budget module.