Spreadsheet-to-Spreadsheet Sync with Apps Script for neighborhood fund ledger

Project info

• ThemeNeighborhood Fund Ledger
• FeatureData Processing · Advanced
• ToolGoogle Sheets
• Price (one price)US$30

Functions used

• Apps Script
• openById
• setValues
• SpreadsheetApp

Two files hold the same content with one click.

Formulas in the file

How to use it

1. 1Create an empty target spreadsheet and copy the ID from its URL.
2. 2Paste that ID in Rekap!H2.
3. 3Paste the code in Apps Script and run sinkronAntarSpreadsheet.
4. 4Approve Sheets access permissions.
5. 5Open the target file and match the totals.

Apps Script code

The script is delivered as a separate Code.gs file inside the ZIP. Paste it into Extensions, Apps Script. A short excerpt:

function sinkronAntarSpreadsheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var idTujuan = ss.getSheetByName("Rekap").getRange("H2").getValue();
  var tujuan = SpreadsheetApp.openById(idTujuan);
  salin_(ss.getSheetByName("Data"), tujuan, "Data");
  salin_(ss.getSheetByName("Master"), tujuan, "Master");
  ss.getSheetByName("Rekap").getRange("H3").setValue("Sinkron terakhir: " + new Date());
}

function salin_(sumber, tujuan, nama) {
  var lembar = tujuan.getSheetByName(nama) || tujuan.insertSheet(nama);
  var nilai = sumber.getDataRange().getValues();
  lembar.clearContents();
  lembar.getRange(1, 1, nilai.length, nilai[0].length).setValues(nilai);
}

Sample content

Columns of the Data sheet:

• Cash Description
• Category
• Residents or Months
• Amount
• Status
• Date

Master sheet items

Dashboard: Neighborhood Fund Dashboard

• Total Cash In
• Total Cash Out
• Cash Balance
• Residents Unpaid

Tips

• Record each fee with the resident name and month
• Keep expense receipts for reporting
• Announce the fund balance monthly in the resident group

The sample data is synthetic.

Price and ordering

Frequently asked questions