OAD Royal Agro Services

Deals in Vegetables and Livestock Farming ie Fish and Goat.

[Ahmardy @Modiibbo_Ahmad]

@elonmusk Western countries should leave African and Asian countries alone and stop destabilizing them. You can't destabilize other people's country and expect to live in peace in your own country

[OAD Royal Agro Services @AgroOad]

@p_dusabimana Hi

[OAD Royal Agro Services @AgroOad]

@Okon_Eteobong @catfishpreneur Great work

[OAD Royal Agro Services @AgroOad]

Do you remember when you joined Twitter? I do! #MyTwitterAnniversary

[OAD Royal Agro Services @AgroOad]

@LagFadamaCares @Abi_Olusanya @adeobayemi @lagosagric @lagosagric1 @Mr_JAGs We are expecting you at Ikola Alimosho Area

[OAD Royal Agro Services @AgroOad]

After 20 weeks of quality feed from a day old, few of the layers layed the first set of egg.

[OAD Royal Agro Services @AgroOad]

First week after successful spawning

[OAD Royal Agro Services @AgroOad]

First Spawning successful all thanks to God, @lagosagric1 @IITA_CGIAR @freshfishalliedventures

[OAD Royal Agro Services @AgroOad]

@WellingtonLanre @DianaUmuhoza_ Badoo D Kick

[Blake Burge @blakeaburge]

Step 13: Excel & G-Sheet Templates

Thanks for reading!

At this point, you've got two options:

1. Take my thread and create a budget of your own.

OR

2. If you'd rather save yourself some time, I'm building a library of templates you can access here: 👇🏻
https://t.co/XXjfU81PwN

[Blake Burge @blakeaburge]

Step 12: Custom Graphs

As a final step, we'll go ahead & add a couple of charts to the dashboard to visualize our data:

• YTD Income: A comparison of expected vs actual income for the year

• YTD Expenses: A comparison of expected vs actual expenses for the year

Like this:

[Blake Burge @blakeaburge]

Step 11: YTD Expense + Net Income

As mentioned above, on the "YTD Dashboard" tab I have also added a summary section for the following:

• YTD Expenses:

Summary totals of allStep 11 Expense Categories

• YTD: Net Income:

Total Income - Total Expense

See here:

[Blake Burge @blakeaburge]

Step 10: Reference Formulas #2

Skip the "YTD Expenses & "YTD Net Income" sections for now.

Complete the same steps outlined in Step 9 for the "Housing" category.

Once done, you can copy & paste the expected + actual fields to the other expenses.

Formulas will carry over.

[Blake Burge @blakeaburge]

Step 9: Reference Formulas #1

Now let's tie our dashboard to each of the monthly sheets.

We'll use the "YTD Income" category as an example.

• Select the "Expected" Cell
• Use the formula below to reference the same cell across all sheets:

=SUM(January:December!C5)

[Blake Burge @blakeaburge]

Step 8: Dashboard

Now that you have all of your monthly tabs created, it's time to build out the "YTD Dashboard"

• Copy the "January" tab & paste it to "YTD"

• Rename headers accordingly

• Add YTD Expenses & Net Income Section

Like this:

[Blake Burge @blakeaburge]

Step 7: Duplicate Sheets

At this point, your "January" tab is ready to go.

But I'm pretty sure there are a few more months in the year.

Don't worry, with a couple of updates you'll be ready to go:

• Add 11 sheets
• Copy & Paste January
• Rename tabs/headings accordingly

[Blake Burge @blakeaburge]

Step 6: Conditional Formatting

As values are populated during the month, I've applied conditional formatting to ALL "Variance" cells.

This provides a quick visual reference to identify if you're "Actual" values are ahead or behind the values you "Expected."

Here's An Example:

[Blake Burge @blakeaburge]

Step 5: Simple Formulas #2

The "Totals" cells inside each category also contain a couple of simple formulas:

• Total "Expected/Actual" –– An easy "SUM" formula to total all subitems.

• Total "Variance" –– An easy +/- formula to calculate our total category variance.

[Blake Burge @blakeaburge]

Step 4: Simple Formulas #1

• To start each month, fill out the "Expected" cell for each category & subitem.

• Fill in the "Actual" cell for each item as transactions happen.

• The "Variance" shows the difference between the two using a simple +/- formula.

Shown here:

[Blake Burge @blakeaburge]

Step 3: Basic Formatting

I like things to be formatted in a similar manner across sheets.

A few quick rules of thumb I've used here:

• Headings: Merge + Center, ⬆ Font, Bold
• Sheet Gridlines: Turned off
• Subitems: Heavy borders
• Totals: ⬆ Font, Bold

For example: