how can I transfer $ from one class to another?

Jul 27, 2006 31 Replies

Good point, a unit is a physical location, not a different company or anything. (the unit or location would be the city name where the people gather for the non-profit activities.)

We're a non-profit group, with say 10 locations in the Texas area. I get a deposit into a local bank account, lets say something like $4,000. The $4,000 is 'split' up to the outlying units, so for example location a (unit a) gets $500, location b (unit b) gets $600, location c (unit c) gets $800 etc. The split is based on a dollar amount per person located at the respective outlying unit, and if one location looses people during a quarter, their portion gets smaller for the following quarter, & vice versa for if they gain people.

We have one rep at each location that I send a monthly account balance to that reflects how much money each unit has to spend, and also reflects the total balance in the physical bank account. Each outlying unit spends money, say, they hold a pizza party for $150. I'll either write the pizza company a check for the invoice or reimburse on of the members directlly the $150, and then record the transaction in the main bank account and also reduce that outlying unit's portion by $150.

Only one location (mine) has any inventory to worry about. Primarily because of the hassles of inventory tracking & management at so many locations.

I'm thinking that subaccounts will work....?

I appreciate your comments as I'm learning how much my years of Quicken use has 'warped' my thinking. :)

Mr.

message

Well, we only track inventory at one location, so that should help the water be less muddy, and cheaper too if a Pro Advisor charges $20K.

I just want to track inventory at one unit, split money in one actual bank account with various locations so they know how much they can spend on their fun activities, and track all of the transactions in a way that I can tell locations on a monthly basis how much they have remaining; hopefully without draining the entire physical bank account.

My fear is tellling outlying units that they have $1,000 to spend and all the outlying units total up to say $10,000 when the bank only really has say $9,500 in it. Then have all the location reps go on a spending spree and find out that the locations reallly didn't have the $1,000 because the total for outlying locations didn;t match the reall bank account register.

I'd much prefer it the other way, the total of outlying unit money split to be less than the bank account so there's some buffer room. However, I'm be required to provide as accurate information as possible to all outlying locations; so the buffer is not an option.

He's not going to charge $20K, the software you would need for good multi-location inventory starts at $20K. It the stuff an order of magnitude more powerful than SlowBooks.

That's what sub accounts will do.

Yep. Sub accounts.

Okay, sounds like you won't be using much of SlowBooks functionality. If the reason to split is to know how big a piece of the pie each has, sub accounts are the way to go.

For the receipts (please don't call them deposits) and expenses classes are the way to go. The P&L by Class report will get you what you want. Export it to Excel and hide columns to get a report for each location.

Your big problem will be in dividing up a receipt to all the locations. SlowBooks will want to throw it all into the main account. Perhaps once a week or once a month you will have to enter a general ledger transaction to split it up.

The balance sheet report will list the total bank account and all the sub-accounts. I think that covers it for you.

I'll play with the account and sub accounts. So inventory should go into the inventory asset account, not matter what the inventory item is? Then when it is sold the sales receipt funds go to the cost of goods sold account & the undeposited funds accounts, then when I go to the bank and take the money in an entry goes into the account register with a 'split' that is linked to each individual sales receipt?

Am I catch> > Well, we only track inventory at one location, so that should help the water

No, read the girls' post again.

I agree - you'll have to use a combination of classes for Income & Expense accounts and subaccounts for any Balance sheet accounts. Make sure when you pay an item you run it through the appropriate sub-bank-account AND assign it the appropriate class (should be the same unit). Anything entered in a sub-bank-account is also considered to be in the main account (eg for reconciliations it will show all activity of the main account PLUS any activity in each sub-account - no need to reconcile each one individually).

You can also set up a P&L account for prior month & filter it to one class, memorize the report under a "P&L Last Month by Class" report group. Then change the class filter to the next class & memorize under the same group. Continue until all classes are represented. Then each month you can print the report group which will give a P&L for each class on a separate page.

Gosh the Allan likes my post ... swoon ....

Inventory (normally) goes into a single inventory asset account. That happens when you either do an item receipt or receive bill and use an inventory item on the items tab.

Inventory items keep track of three accounts, the Income account when you sell it, the COGS account when you sell it, and the Inventory Asset account when you either buy or sell it.

Here's how it works. When you enter a bill with an inventory item, SlowBooks adds it to A/P and Inventory Asset [and adjusts the average cost.] When you write an Invoice, SlowBooks adds to A/R and Income, it also subtracts from Inventory Asset and adds to COGS. A Sales Receipt is the same as an Invoice, except instead of hitting A/R it hits a cash account.

If you used an Invoice the check arrives and you go to payments. You pick the customer and the Invoice(s) and put in the amount. SlowBooks subtracts from A/R and adds to undeposited funds. When you use a Sales Receipt you skip this step.

Time to go to the bank. You do a deposit and SlowBooks subtracts from undeposited funds and credits a bank account / sub account. Now your problem starts. You have to pick the right bank account / sub account. If you have checks going into many different sub accounts this is where you have to make a decision. Put it all into the operating / catch all sub account and split it up later, or do a bunch of separate deposits. If you put it all in one chunk your records will match the bank when you reconcile your bank account, if you do many deposits you'll have to add them all up to match the bank statement.

My thought to you is when a bunch of checks come in either use stickies or a file with dividers to keep track of which sub account each check should go into.

I think we've done all the bookkeeping 401 class for a while.

You did't read the OP's post. The cash balance allocation is based on the number of peole working at each unit.

I did, you didn't. Not all checks the OP gets are divided based on people.

Correct. We get a quarterly amount which is sent to us and it gets split among the subaccounts, based on people levels.

In addition to that the outlying locations send us $ on occasion to be put into the physical bank account and added to their subaccount balance.

I cut checks directly to vendors or reimburse a person directly, keep the receipts for documentation and subtract the $ from the subaccounts.

When all is said and d> > You did't read the OP's post. The cash balance allocation is based on the

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required