loading.gif
Notes
Login Sign Up Shopping Cart 简体中文
Add to my favorite categories
category Financial Accounting
Path Yahoo Bid > Computer & Accessories > Software > Windows > General Business Software > Financial Accounting
Remarks
Add my favorite keywords
Keywords
category Financial Accounting
Remarks
Join my favorite seller
Seller Ex5b3***
Remarks
Add to my blacklist seller
Seller Ex5b3***
Remarks
Yahoo Bid Computer & Accessories Software Windows General Business Software Financial Accounting
マンション管理組合会計マクロ
        

  • Product Quantity
    : 1
  • Starting Bid
    :150,000円
  • Highest Bidder
    : / Rating:
  • Listing Date
    :2026年01月12日 10時00分
  • Bidding closes on
    :2026年01月19日 10時00分
  • Auction Number
    :g1196447766
  • Condition
    :State it in the description
  • Automatic Extension
    :Yes
  • Authentication
    :No
  • Early Closing
    :Yes
  • Can I return the product?
    :no
  • Description
  • Q&A ()
  • Cost Estimator
  • Problem Item Response Procedur
マンション管理組合の決算書を作成できるマクロです。

特徴は
Excelで 仕訳日計表を作成します。1行仕訳です 自動的に 総勘定元帳のような科目の列に転記されます。
仕訳日計表には年度毎の数字だけをいれてください。

前期貸借対照表があるときは 期首開始日に諸口仕訳で残高を入力します。

組合ごとに科目が異なりますので科目設定をします。科目数は制限ありますが科目名は自由です。
全体の決算書が ボタン1つで できます。
管理費会計と修繕積立金会計にわける必要がありますので 画像のようにボタン1つで 区分しますので
科目と金額と配置ができていますので Excelに張り付けしてください。 組合の事業年度を入れてください。

科目別月別集計表は 仕訳日計表から作成します。期首年月日をポップアップから入れると年度月が自動で表に転記されます。
*科目月別集計表作成するときの 仕訳日計表はエクセルなので 1100行まで試しましたが大丈夫です。
*科目別集計表は科目ごと 借方合計 貸方合計 借方-貸方の数字 で作成され借方合計貸方合計はマクロで非表示表示ができます。
*仕訳日計表の行数が500以上だと 読込が遅くなりますので500行目に固定してあります。

管理費会計はマクロで作成します。修繕積立金会計は 作成行数がわずかであることから管理会計から枠をコピーしてください。

次期の管理費会計 修繕積立金会計の予算書は 次期の科目別集計表の予算案と同じですから作成対象としていません。


開発の経緯
マンション管理組合の理事を長く経験しており自主管理から管理会社管理数社を体験しています。
その中で 小規模マンション管理組合で発生するトラブルは体験知とて活きています。
管理会社 自主管理 管理会社+自主管理部分 のすみわけがあると 助かる管理組合があると思います。
管理会社は正確には共用部管理会社です。
理事長自体がしっかりとできないと 共用部管理会社もすることがありません。


ソフトの価格  商品の提供方法は ダウンロードかメール送信になります。

マクロを使用すること 初期設定がいること 導入時のお困り事の相談があると思いますので
この価格とさせていただきます。 *不要な方については申込できません。

導入時年度の決算まではきっちりと決算書まで作成までフォローいたいします。
12回の相談をおつけいたします。

当初設定については決算書を拝見させていただきます。


希望
現地にいかないといけないこともあるので山手線の左側の駅から徒歩でいけるマンション管理組合様だけ購入検討願います。
管理会社の相場は 25戸でも150万はするのではないでしょうか。安くはないのでよくご検討願います。

管理組合のあるある困り事
管理費長期滞納 裁判
共用部迷惑行為者
店舗営業者のゴミ出し迷惑行為騒音タバコ捨て
民泊外国人
老朽化マンションの長期修繕積立
共用部管理会社社員が訪問してこない
監視カメラがない







(2025年 8月 15日 17時 41分 追加)
現地にいかないといけないこともあるので渋谷駅-新宿駅-池袋駅 山手駅から徒歩でいけるマンション管理組合様だけ購入検討願います。
*これ以外はご相談ください。

(2025年 8月 15日 17時 53分 追加)
30戸以下の小規模マンション管理組合が対象のソフトです。これ以上の場合は相談願います。

(2025年 8月 15日 17時 59分 追加)
現地にいかないといけないこともあるので東急菊名駅-東急渋谷駅-新宿駅-池袋駅 山手駅から徒歩でいけるマンション管理組合様だけ購入検討願います。
*これ以外はご相談ください。
Please log in before asking questions
Question list
All replies from original sellers (total number of questions: items)
After the seller responds, the original page will display the question
Product Price JPY
Japanese Consumption Tax(10%) JPY

A 10% consumption tax is applied to goods and services in Japan. The price may include the tax or it may be added separately. Please check the price details when ordering.

Note: This is a domestic sales tax applied within Japan.

Japan Local Shipping Fee JPY Japan Local Shipping Fee Reference
Product Weight KG The maximum weight limit is 30 kg
International Shipping Methods
Proxy bidding and purchasing services are becoming increasingly convenient. However, overseas shopping carries certain risks and issues. To reduce these risks and enhance shopping safety, please be sure to read the following information:

1. International Shipping

   Air Freight: If the item status is not confirmed within two days after the arrival notice, any customer complaints cannot be addressed with the seller.

2. After Receiving the Product

Please confirm and inspect the product as soon as possible to ensure that the product specifications, quantity, accessories, and description are correct

If, unfortunately, there are any issues, you can refer to the following examples on how to report related product problems:
1. Example of missing product information
2. Example of product not matching provided information
3. Example of damaged product information

Important Notes: 1. If the seller is unwilling to ship overseas or is unaware that the product will be shipped overseas, the international shipping cost for returns or exchanges will need to be borne by the member. You may refer to the EMS e-Express fee inquiry from the post office. If it involves alcoholic beverages or items that affect flight safety, the post office cannot be used for shipment, and only DHL can be used to ship back to Japan.
2. During the product complaint handling period, please retain the complete outer packaging of the product (including the shipping label information), and refrain from attempting any repairs or altering the original condition. Any modifications may result in the inability to process the case.

3. After Inspecting the Product

After receiving and inspecting the item, if you have any questions, it is recommended to contact Letao within 2 hours. Here are some reminders:

1. Please do not unpack, use or repair the received item yourself, and be sure to keep the original packaging to facilitate subsequent handling of related matters, so as to avoid changes to the item that may cause the seller to be unwilling to process.

2. You can call customer service, and the customer service will leave a message for you as below. Please provide the following information:
"Hello, we will first help you establish a complaint case for Product ID: _______ .But we need you to 2-3 clear photos of the product issue, including photos of the product problem, product packaging, shipping details slip, and outer box. Send them to service@letao.my and inform us of your desired resolution (failing to provide this may result in an inability to process subsequent matters). After sending the email, notify us in the customer service message. We will confirm with the seller as soon as possible. and if there are any related questions, we will contact you through the customer service message. Thank you for your cooperation."

Please provide:
1. "Product ID"
2. Photo of the "Delivery Note" (if any)
3. Photos of the outer box (including inner and outer packaging)
4. Photos of the product (Please include relevant descriptions to help us confirm with the seller)

Important Notes:
1. Do not include foreign text or other products in the background of the image.
2. Please keep the complete product packaging (including the shipping label information), and refrain from repairing or altering the original condition on your own, as any changes may result in the case being unable to be processed.
3. Please provide the relevant information within 48 hours to avoid missing the golden hour for reflection and causing situations that cannot be handled.
4. Due to 99% of Japanese sellers being unwilling or unaware of shipping goods overseas, if a seller is willing to handle the issue, the goods must be sent back to Japan, and the international shipping costs incurred must be borne by the member. Letao will use postal EMS international express to send the goods back to Japan.
5. As the goods are purchased from overseas, it may take approximately one to two weeks to complete the relevant processing procedures when issues arise with the goods. Please be reminded that you can inquire about the approximate cost through the EMS service at the post office.

4. FAQ

1. Issue of Authenticity: If antique or branded goods are found to be counterfeit upon receipt, clear photos showing the differences between the genuine product and the imitation must be provided as evidence. If unable to provide relevant proof, assistance can be sought to find a third-party reputable organization for a premium authentication service .
2. Leaking Iron Teapot: If an antique iron teapot is leaking, please take clear photos of the leaking area and provide them.
3. Transport Damage: If the goods are damaged during international shipping (to the pickup point), you need to provide photos of the outer packaging of the parcel and clear photos of the damaged goods' outer packaging.

※ Note: Photos provided to sellers should not contain any foreign-related information.
You may also like
    Seller products
    Excite Translate
    Add to watchlist and notes
    Product name: マンション管理組合会計マクロ
    Notes:
    Customer service hours:
    • Monday to Friday 10:00-18:00
    Customer service hotline:
    Customer Service Email: service@letao.my