Problem: You can get a budget to GL report. You can get an open purchase order report. You cannot get the two combined.

Suggestion: Create a report that adds open purchase orders to existing general ledger amounts and compares the sum to the budget.

Benefit: Real time comparison of actual and committed expenditures to budget, significantly improving internal and financial control.

Comments

  • PO's generally are for items that go into inventory, which is a balance sheet item. Budgets typically refer to income statement accounts, so not sure this is feasible or a good idea. I see where you are coming from, though - maybe a crystal report or export to a database comparing data. Hope that helps in the short term.