From Nookipedia, the Animal Crossing wiki
Money rocks, or Bell rocks, are rocks that spurt Bells when hit with a shovel or an axe. Every day, one of the rocks in the player's town will turn into a money rock and can be hit repeatedly for increasing amounts of money. The allotted time window for a hit to produce money decreases after each hit. After all the money has been collected, the money rock will go back to being a normal rock. In all games, every bag spouted after the fourth consecutive bag/coin will play the '1-Up' noise from the Mario series.
The amount of money the rock gives varies from game to game and depends on how fast it is hit, the level of yellow Feng Shui, and, in Animal Crossing: City Folk, what it is hit with. Any obstacle adjacent to the money rock will also prevent bags from spawning there. For towns with more than one player, each player gets the money rock from separate random rocks.
In Animal Crossing
In Animal Crossing, the rock will spurt out up to 23,300 Bells as three sacks of 100, three sacks of 1,000, and two sacks of 10,000. Having high levels of any (not just yellow) feng shui will increase the chance of more money spouting from the rock. Also, the money rock glows red when hit and gradually fades to gray, giving a visual timer as it will continue to spout money for as long as the rock is red. In later versions the rock simply remains gray.
Having a good money fortune from Katrina will dramatically increase the amount of money received from the money rock.
The amount of money that can be collected from money rocks in a year is 4,867,800 bells (4,867,800 in a leap year).
In Wild World
In Animal Crossing: Wild World, the rock in the player's town will release up to 8,500 Bells as sacks of 100, 200, 400, 800, 1,000, 2,000, 4,000 Bells, in that order. High levels of yellow feng shui may allow for an additional 8,000 Bell bag to appear.
The amount of money that can be collected from money rocks in a year is 3,102,500 bells (3,111,000 in a leap year).
In City Folk
In Animal Crossing: City Folk, the amount of money that comes out is different from past titles. The order goes: 100, 200, 300, 500, 1,000, 2,000 and finally 4,000. If the player uses a silver shovel (golden shovels do not work), one or more of the money bags may be worth double, with a signature noise and sparkle. This has a 10% chance of happening for each hit. It has been proven that high yellow feng shui (over 73 yellow feng shui count) means that an 8,000 Bells bag will appear if the rock is hit fast enough.
The maximum amount of money that can be collected from money rocks in a year is 8,796,500 (8,820,600 in a leap year) while the minimum is 2,956,500 (2,964,600 in a leap year).
In New Leaf
In Animal Crossing: New Leaf, if the money rock is struck with an ordinary shovel, players can receive up to 16,100 Bells (this time, feng shui is not a requirement for the 8th money bag), with almost no chance of receiving ore. The order pattern goes with either 100, 200, 300, 500, 1,000, 2,000, 4,000, and 8,000 Bells in that order or 100, 200, 300, 500, 500, 1,000, 2,000, and 4,000 Bells, with the 500 Bells appearing twice, therefore reducing the total to only 8,400 Bells. With good money luck, however, players can receive up to 32,000 Bells and there is a rare chance of a bunch of ore appearing instead of the daily money. Ore is sold for a minimum of 2,000 bells each in Re-Tail.
The amount of money that can be collected from money rocks in a year is 5,876,500 (5,892,600 in a leap year).
After every hit against the rock, the player will rebound, causing the player to lose time and making it impossible to collect all of the potential money sacks. To prevent this, players can dig holes behind themselves to create a wall to prevent getting knocked back too far. Examples are shown below.
Natural features, such as trees and cliffs, if close enough, can also be used to prevent kickback, taking place of one or more holes.
It should be noted that in Animal Crossing: New Leaf, the left formation in the ones shown above will prevent the 8th money bag from appearing, therefore halving the amount that the player receives from money rocks. In other games, this is less of an issue, since the 8th bag only appears if the player has excellent yellow feng shui.