• Overview
• Calculation of write-up/down and carry forward amounts
• Time Analysis documents
• Expense Analysis documents
• WIP Analysis documents
• Billing Analysis documents
• Costing of expenses
• Invoice Analysis documents
• Budget Analysis documents

Examples - Calculation of Write up/down and carry forward amounts

Billing and Time analysis reports:

Example 1

Time entered for 1500.00. Create an invoice for 1000.00. The write down is (500.00).

In this example the write up/down amount in the billing and time analysis documents is (500.00).

1. Invoice amount - Time entered = Write down

   1000.- 1500.= (500.00)

The profit is 1000.00. The calculation of profit is as follows:

Billed time & expense + write up/down - cost = Profit

1500.+ (500.00) - 0.= 1000.00

Example 2

In order to bill the time amount with 2 entries of $1000.00 and $500.00, we can carry forward the write down amount.

In this example the write up/down amount in the billing and time analysis documents is adjusted to 0.00.

(Invoice amount - Time entered )+ carry forward = Write up/down

(1000.- 1500.00) + 500.= 0.00

(500.00) + 500.= 0.00

The billed time and expense total is adjusted for the carry forward amount

Billed Time - Carry forward adjustment = Total billed time

1500.- 500.= 1000.00

The profit is 1000.00. The calculation of profit is as follows:

Billed time & expense + write up/down - cost = Profit

1000.+ 0.- 0.= 1000.00

Example 3

Move to the next month. Add a invoice for 500.00. Mark the carry forward of 500.00 in the invoice. The WIP balance for the client is 0.00.

In this example the write up/down amount in the billing and time analysis documents remains as 0.00. The Billed Carry Forward item is add to the Billed Time and Expense total.

The profit is 500.00. The calculation of profit is as follows:

Billed time & expense + write up/down - cost = Profit

500.+ 0.- 0.00 = 500.00

WIP analysis reports: In the period that the carry forward is created

1. In the above example the "Work in Process -detail" report would show (500.00) in the "Total Adjustment (write up/down) in Billed (B) items" line.
2. In the above example the "WIP reconciliation" report would show (500.00) as "Write up/down during period" and 500.00 as "Carry forward during period".
3. In the "WIP analysis" and "WIP summary" reports, the sum of Adjustment and Write up/down amounts would equal the sum of the write up/down amounts in the WIP reconciliation and the WIP detail reports.

(500.00) + (0.00) = (500.00)