Promotional Funding Solution

Business Systems Implementation &
Support

QuickBooks extensions

Custom Programming



Join Our Email List Email:

Promotional Funding Agreements Accounting Solution

A major retailer implemented a new program to recapture costs from promotions with promotional funding agreements but the complexity of the spreadsheet that they started with QUICKLY outstripped the accounting teams ability to manage the changes.

BIG worked with the accounting team to find the similarities between the new contracts and built a system to capture the information and generate both calculations for revenue recognition and Invoices for sending to the manufacturers. Over time we added additional features to help them manage the program

Some of the features we added are Contract Status, Receivable history, Contact Approval, and Multi-Region support. Because of the way we designed the solution, The Promotional Funding Agreement Accounting solution is easy to implement and tailor to an organizations needs.

	Approach: The tool captures annual contract information and then allows users to create invoices and revenue entries quarterly.
	Secure but Simple: Because the system uses SQL integrated security, it is a highly secure solution. The use of roles and feature based security makes the highly secure system manageable by end-users. The feature based security (i.e. create contracts vs record revenue) is a strong feature in environments where separation of duties is a concern.
	Integration with Excel: Aging data is exportable to Excel, an accountant's favorite tool.
	Standardized Reports ready for customization: In addition to standard invoices, statements and aging reports ready for your unique customization, all of the below reports are also available:
	Review Income Recognized – Displays Income received for the given period Review Income To Be Posted – Shows the group of Items that will Post income. Created when Generate Income Items was run. Records may have already posted. Claims Open – shows all claims that still have a balance Claims Paid – shows all claims that have been paid and when Claims Adjustments – shows all claims that have had adjustments and what they are Claims Receivable History – For any given Claim, shows all of the detail transactions that make up the current balance Claims Posted Log – shows all claims that were posted for a given period Aging Report – Shows Aging of all claims with an outstanding balance Preview Invoices – Prints the Claims Invoices Statement of Account – For a given Manufacturer – shows balances of all contracts Contract Detail Approvals – lists all contracts that have been approved or not approved Performance Requirements Report – shows all contract requirements and whether they have been met or not Billing Proof of requirements Report – shows all Billing requirement and whether they have been met or not Income Exceptions report – Shows any Contracts that have not been billed or any Contracts that have not received any income for a given period YTD Rev to Bill Report – shows by Quarter the revenue, billing and adjustments for each contract.