Skip to main content
Skip table of contents

Project Setup

Overview

GoldFinch allows you to track revenue, material, and service costs to projects. You can then report profit and loss by project or project tasks.

You should not use Accounting Variables to manage project financials because the number of projects could grow over time, and it is tedious to sync projects and Accounting Variable tables.

Project

Set up a numbering series with Name = Project for the Project. Check the Manual No. field if you prefer to enter Project No. manually.

image-20240406-195902.png

Enter Customer and other relevant information on the project table.

image-20240406-200149.png

Project Task

Project Task is typically used for billing purposes. If you want to use the Timesheet feature to track time, create Work under the Project Task. See Timesheet Management for more information.

image-20240406-200252.png

You can enter Billing Task Budget Cost and Billing Task Budget Revenue.

Both Billing Task Actual Cost and Billing Task Actual Revenue are calculated from the Project Ledger Entry table.

image-20240406-201647.png

Work

Set up a numbering series with Name = Work for the Work. Check the Manual No. field if you prefer to enter Work No. manually.

image-20240917-194308.png

Financial Report Using Project Ledger Entry

To track actual expenses and revenues using the Project Ledger Entry table, navigate to Custom Settings\System Settings. Then, create a new parameter:

  • Name: EnableProjectLedgerEntry

  • Value: True

image-20240406-200638.png
image-20240406-200407.png
image-20240406-201924.png

When posting from Purchase Invoices, Sales Invoice, Item Journal, and General Journal, if both Project and Project Task fields are filled in, Project Ledger Entries will be automatically created.

Transaction Types

Project Costs

Project Revenue

Purchase Invoice

Line Cost Incl. Landed Cost

Sales Invoice

Line Cost

Line Amount

Item Journal

Line Cost

General Journal

GL Accounts with Statement Type is Income Statement and Account Type is not Revenue

GL Accounts with Statement Type is Income Statement and Account Type is Revenue

By creating a list view or custom Salesforce reports, you can compare actual vs budget for costs and revenue by Project or Project Tasks.

image-20240406-202833.png

Financial Report Using GL Entry

If you do not want to use Project Ledger Entry, you can report actual profit and loss by project using the GL Entry table. Use the sample report named GF4020 GL Transactions by Project.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.