User profile for user: SeanLi
SeanLi Author
User level: Level 1
0 points

Bi weekly Income for numbers template

All,
Can anyone advise on this issue. i searched this forum and found nothing that matched my need. I get paid biweekly and would like to modify the template in numbers 09 to give the same information it does but on a bi-weeklyschedule with monthly expenses since my income is bi-weekly but my expenses are monthly. thanks in advance for your help.

Best Regards
SeanLi

MacBook Pro, Mac OS X (10.6), SwweeT!

Posted on Sep 9, 2009 7:16 PM

Reply
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
30,540 points

Posted on Sep 10, 2009 7:01 AM

I assume you are using the personal budget template. I assume you don't really need to break everything down biweekly. And is it biweekly or twice a month?

If you are using the template as provided by Apple and if you get paid twice a month (not biweekly), you can change the Monthly Net Income table in the following manner:

Change A2 to read "Biweekly income"
Change A5 to be =2*A2+A3

For biweekly it will be more difficult because not all months are equal. Some months will have two pay periods and some will have three. The template is not set up to handle that situation and it would be very difficult (though not impossible) to modify it. You would probably be better off putting your month-by-month income directly into the Annual Budget table and deleting the Monthly Net Income table. Alternatively, you could determine your average monthly income and put it into the Monthly net Income table.
View in context
12 replies
Question marked as Top-ranking reply
User profile for user: Badunit
Badunit
User level: Level 7
30,540 points

Sep 10, 2009 7:01 AM in response to SeanLi

I assume you are using the personal budget template. I assume you don't really need to break everything down biweekly. And is it biweekly or twice a month?

If you are using the template as provided by Apple and if you get paid twice a month (not biweekly), you can change the Monthly Net Income table in the following manner:

Change A2 to read "Biweekly income"
Change A5 to be =2*A2+A3

For biweekly it will be more difficult because not all months are equal. Some months will have two pay periods and some will have three. The template is not set up to handle that situation and it would be very difficult (though not impossible) to modify it. You would probably be better off putting your month-by-month income directly into the Annual Budget table and deleting the Monthly Net Income table. Alternatively, you could determine your average monthly income and put it into the Monthly net Income table.
Reply
User profile for user: Ashka
Ashka
User level: Level 4
3,891 points

Sep 13, 2009 1:51 AM in response to SeanLi

Hi SeanLi,
If you are looking at making your own budget spreadsheet you could use your paydays as the header rather than months.
Monthly expenses would be debited on alternate paydays except for the twice a year extra pay between the monthly payments.

It's easy to set the header payday dates > enter two pay dates in January > select the two and drag across the columns.

I am paid every 4 weeks ~ not monthly so there is one extra pay per year. I have been running my spreadsheet budget on paydays rather than months for years 🙂
Reply
User profile for user: SeanLi
SeanLi Author
User level: Level 1
0 points

Sep 10, 2009 3:45 PM in response to Badunit

Thank you Badunit.

i am on a bi-weekly (26 pay periods per year). I have changed the annual budget sheet to match the bi weekly dates so i will go ahead and just input the income into the annual budget table. its not as intuitive as i would like but it will do what i need until i can create a spreadsheet of my own.
i was hoping more people who get paid bi weekly would have a solution but this works.

Thanks Again.
SeanL
Reply
User profile for user: SeanLi
SeanLi Author
User level: Level 1
0 points

Sep 12, 2009 11:47 AM in response to Badunit

Thanks again for following up!!
it is a bit of a task. i tried a few thing but i figured may just be best to figure the 2 months where there are 3 pay periods, and enter those as bonuses. for me, they are anyway since i have to live off 2 the other 10 months.
i realy appretiate all you help in this.
i will kepp working at it and maybe i can find a solution for others, though it seems i may be the only one who wanted this.

Best Regards,
SeanL
Reply
User profile for user: SeanLi
SeanLi Author
User level: Level 1
0 points

Sep 15, 2009 2:58 PM in response to Ashka

Thanks AshKa.
I think i got that to work, its just getting the monthly expenses to subtract from just one instead of from each entry. since my geneses are more than each bi-weekly check its going negative. i figured just input the total monthly expenses /2. That works too i guess. thanks for the advise on the dates, but i have been entering them manually since numbers does not seem to recognise the 2 week interval when i tried to drag across the columns.
Reply
User profile for user: Badunit
Badunit
User level: Level 7
30,540 points

Sep 10, 2009 5:56 PM in response to Badunit

Not easy. Actually, the number of Fridays per month is easy but the number of pay checks is not. I think I'll hang this idea up. You could enter years worth of pay periods by hand quicker than I can develop a formula for you. What I would do is

1) Enter your biweekly pay amount in the Monthly Net Income table. Delete the sum at the bottom of the table.

2) Add a row to the Annual Budget by Month, right below the month name, that has the number of pay periods for the month. Enter them by hand.

3) Modify the Available Cash line to so the formula is Other Monthly Income + Biweekly Pay * Pay Periods.
Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Bi weekly Income for numbers template

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up