MetaBroadcast process

MetaBroadcast Mgmt Accounts

1. Download list of bank transactions for current month from Barclays in Excel
2. Add latest month’s bank transactions to bottom of Bank tab
3. Classify each bank transaction to the correct nominal account on Financial Force - this gives you all bank transaction but doesnt include any journals that doesnt go through the bank (AP, AR, Deferred income, PAYE for current month)
4. Add any AP invoices to the AP tab based on purchases folder on dropbox plus own knowledge
5. Add any new AR invoices to the AR tab based on sales folder in dropbox, accounts@metabroadcast.com email account or Google CF forecast
6. Add any other adjustments to the Other tab
1. Deferred income (“for recurring sales”) release from previous period
2. New deferred income balance
3. PAYE/NI liability for current month from MB payments smartsheet tab
4. Secondary bank account movement allocated to Office Expense (as the amounts going through this account are very small and generally for ofice related items)
7. Construct general ledger based on completed four tabs above
1. Copy paste TB Key 1, TB Key 2 and TB Key 3 (for each transaction there could be 3 nominal accounts affected: the account to be debited, the account to be credited and VAT) underneath each other for each tab into the GL tab
2. This creates a general ledger of all journals
3. Now you can use a pivot table to construct a P&L and BS
8. Run pivot table to get journal for current month that needs to go in Financial Force:
1. Copy last month’s journal tab and rename
2. Update pivot table and filter for current month
3. Send to Terri for posting to Financial Force

MetaBroadcast CF updates

Link: https://docs.google.com/spreadsheets/d/17IO6On2m7K5ri750iQAjAP_QAMI02ze12HfUVCIgI7w/edit?ts=59036230#gid=756051210

1. Update all payment receipts by updating New Sales and Recurring sheets (do not update the CF detail tab directly). Check to see that the CF Detail sheet cash inflow for the preceding weeks are ‘zeroed’ out
2. Check that all payments made match with the cash outflow in the preceding weeks (ie that you are not double counting payments already made or missing payments that were meant to be paid in the past but for some reason have not yet been paid)
3. After #1 and #2 are complete, delete all columns up to the last week.
4. Enter today’s bank balances on the top of the current week
5. Add the word “Start” in cell F1 (which should be the beginning week)