Anthony J. Pennings, PhD

WRITINGS ON AI POLICY, DIGITAL ECONOMICS, ENERGY STRATEGIES, AND GLOBAL E-COMMERCE

The Claim and the Digital Spreadsheet in AI4D Implementation

Posted on | October 14, 2026 | No Comments

Citation APA (7th Edition)

Pennings, A.J. (2026, Oct 15) The Claim and the Digital Spreadsheet in AI4D. apennings.com https://apennings.com/artificial-intelligence/the-claim-and-the-digital-spreadsheet-in-ai4d/

Introduction

A claim, in public finance and in the spreadsheet-logic frame used here, is a recorded right to resources that has not yet been converted into a completed use. It is the starting entry in the conversion sequence. An office or officer holds a recognized entitlement such as an appropriation in a budget, a receivable on a ledger, a stablecoin balance credited to an agency account, a mobile-money float assigned to an agent, or a tax assessment that is due.

The claim exists because it has been written down. Max Weber’s file made such entitlements durable, while the spreadsheet performs the same work today (Weber 1978). Once the row is entered and reconciled, the claim can be reviewed, transferred, or challenged by a later officer. Until it is spent, appropriated, or otherwise executed, it remains only a claim.

In the AI4D sequence, the claim is what must move. Liquidity becomes an allocation when the claim is assigned to a specific purpose or account. That allocation becomes infrastructure or a service only when the claim is cleared through the necessary approvals and turned into real resources, such as labor hired, goods procured, power consumed. Pressman and Wildavsky’s clearance points are the successive agreements required before the claim can advance to implementation [2] (Pressman and Wildavsky 1973).

If any joint action fails, the claim stays on the sheet and the public purpose is not completed. Not every balance is a usable claim. A figure that cannot be appropriated, that lacks an audit trail, or that cannot be matched to available real resources is only a number. In Tier 4 and Tier 5 settings the practical test is whether the claim can be moved through mobile-money or spreadsheet systems into an action an officer can authorize.

Registration

A claim is registered by its entry into a reconcilable row in the spreadsheet. Spreadsheet logic structures the claim’s identity and reference, the account or party that holds it, the amount, and the date and status. The row must match a source document and balance with the rest of the sheet. Once posted, it becomes a durable file entry that later officers can read and act on (Weber 1978).

AI can suggest the coding or flag errors, but the registration itself is still the human or system act of writing that reconcilable row. Without that entry, the claim does not exist for subsequent administration.

The Three Clearances

A claim becomes a service only after it is recorded, appropriated, and converted into real resources. Each step is a clearance. Spreadsheets have long been the practical file in which those clearances are made visible. First on paper ledgers, and later on digital sheets, AI will read and propose changes to the same rows; it will not replace the clearances (OECD 2025; World Bank 2025).

Traditionally, recording the claim meant an official entered the entitlement into a bound ledger or paper file, naming the source, amount, account, and date. A second officer or auditor checked that it matched the authorizing document. Weber’s file made the claim durable and reviewable; without the written row it did not exist for later action (Weber 1978).

Paper spreadsheets and early digital sheets performed the same registration. Columns held the identity, the chart-of-accounts code, the amount, and the running balance. Reconciliation, the row summing correctly and tracing to a source, was the clearance. AI will propose the coding, flag mismatches with source documents, and draft the accompanying note. The registration itself remains the act of posting a reconcilable row that a later officer can open and stand behind. The model does not create the claim.

Appropriating the claim required assigning it to a specific purpose and authorizing its use. In traditional practice this meant a budget warrant, a commitment voucher, or a supervisor’s signature moving the amount from “available” to “committed.” Multiple actors often had to concur as noted by Pressman and Wildavsky’s clearance points (Pressman and Wildavsky 1973).[1] If any refused or delayed, the claim stayed on the sheet.

Spreadsheets made the appropriation visible as a change in status or a transfer between columns. Linked sheets or simple financial systems let higher offices see the commitment without waiting for a physical file. The clearance was still by a human. An authorized officer changed the status or approved the transfer. AI can recommend which purpose best matches policy rules or real-resource forecasts and can highlight conflicts with other commitments. It can prepare the documentation for the approval step. The appropriation clearance itself remains with the officer or the rule-based process that has legal authority. In settings where formal and informal practices diverge, the model’s clean recommendation does not close the joint action (Riggs 1964).

Converting the claim into real resources turns the appropriated amount into labor, goods, power, or a delivered service. Traditionally this meant procurement, hiring, or cash disbursement, followed by evidence that the resource was received. Monitoring compared the executed amounts with the appropriated ones. Failures such as missing cash float, absent infrastructure, or incomplete delivery left the claim unconverted. Spreadsheets tracked the conversion through expenditure columns, variance reports, and reconciliations against bank or agent statements. They made over- or under-spending visible and supported later audit.

The sheet did not itself buy the goods or staff the post. It recorded whether the conversion had occurred. AI will monitor continuously, flag variances in real time, forecast whether power, materials, or agent float will be available, and suggest corrective reallocations (OECD 2025). It can draft exception reports. The conversion still requires the real resource and the final human or authorized clearance that accepts the delivery. Where connectivity or cash is intermittent, manual fallbacks remain necessary. The model shortens the time between a recorded claim and a visible proposal; it does not complete the service.

The Excel Spreadsheet

Across all three steps the spreadsheet has been the system of record that makes the claim reviewable and the clearances traceable. It holds the rows against which actions are checked and by which a later officer can still reconstruct what happened. Excel is the dominant digital form of that file in most public-finance settings.

Recording occurs when an officer or an import enters the claim into cells that capture identity, account code, amount, date, and status. Built-in formulas and pivot tables make the reconciliation visible. Appropriation appears as a status change or a transfer between columns or linked sheets.

Conversion is tracked through expenditure columns, variance formulas, and reconciliations against bank downloads or agent reports. Conditional formatting and simple macros flag exceptions for an officer to clear.

Excel does not create, authorize, or execute the claim. It holds the rows that later officers and auditors open. Its practical advantages are ubiquity, low training cost, and the ability to work offline or with intermittent connectivity—important in Tier 4 and Tier 5 offices. Its limits are version control, broken links, and the ease with which an unlogged change can obscure the audit trail.

Many financial-management systems still export to or rely on Excel precisely because it remains the readable working file. AI tools that sit on top of Excel or read its files can suggest account codes, highlight mismatches, draft variance notes, or forecast whether real resources exist (World Bank 2025). They operate on the sheet; they do not replace the act of posting a reconcilable row or the officer’s clearance.

The AI’s Role

AI operates on the registered claim without performing the clearances themselves. At recording it proposes the account coding, flags mismatches against source documents, and drafts the accompanying note, yet the reconcilable row is still posted by an officer or authorized process so that the file remains reviewable (Weber 1978).

At appropriation it recommends a purpose that matches policy rules or real-resource forecasts, highlights conflicts with other commitments, and prepares the supporting documentation; the decision that moves the amount from available to committed stays with the officer or rule-based authority that must still clear the joint action (Pressman and Wildavsky 1973).

At conversion it monitors execution continuously, flags variances in real time, forecasts whether power, materials, or agent float will be available, suggests reallocations, and drafts exception reports; final acceptance of delivery and the completion of the service remain human or authorized clearances, especially where connectivity or cash is intermittent (OECD 2025; World Bank 2025).

Across the sequence AI therefore extends the speed and pattern recognition applied to the spreadsheet rows. It does not register, appropriate, or convert the claim. The historical requirement holds as each clearance must still be made, and the file must remain readable by a later officer.

Adding the AI to Development Public Administration

In AI4D, the claim remains what the file records and what the conversion chain must still carry forward (Weber 1978; Pressman and Wildavsky 1973). The digital spreadsheet, most often Excel, continues as the practical system of record that renders each clearance visible and reviewable. AI extends the speed and pattern recognition applied to those rows. It does not register, appropriate, or convert the claim on its own.

The historical requirement currently stands. Each clearance must still hold, and the file must remain readable by a later officer. That is the condition under which a recorded right to resources becomes a completed public service.

References

Lundy, Timothy; Ramos Maqueda, Manuel; Patel, Shyam Jayanti; Rogger, Daniel; Sacco Capurro, Flavia; Silva Fuentealba, Josefina. 2026. How Is Government Using Artificial Intelligence?. Policy Research Working Paper; 11466. © World Bank. http://hdl.handle.net/10986/45633
OECD. 2025. Governing with Artificial Intelligence: The State of Play and Way Forward in Core Government Functions. Paris: OECD Publishing.
Pressman, Jeffrey L., and Aaron Wildavsky. 1973. Implementation: How Great Expectations in Washington Are Dashed in Oakland. Berkeley: University of California Press.
Riggs, Fred W. 1964. Administration in Developing Countries: The Theory of Prismatic Society. Boston: Houghton Mifflin.
Weber, Max. 1978. Economy and Society. Edited by Guenther Roth and Claus Wittich. Berkeley: University of California Press.
World Bank. 2025. Assessments of AI adoption in government (GovTech and related reports).

Notes

[1] In their 1973 classic book Implementation, Jeffrey Pressman and Aaron Wildavsky defined clearance points (or decision points) as specific moments in time and space where distinct actors or organizations must reach an agreement before a policy or program can move forward.
[2] Pressman and Wildavsky defined ‘implementation’ as “to carry out, accomplish, fulfill, produce, complete.”

© ALL RIGHTS RESERVED

Not to be considered financial advice. AI is often used, and results are thoroughly interrogated. Links are used for some citations.



AnthonybwAnthony J. Pennings, PhD is a Professor at the Department of Technology and Society, State University of New York, Korea and a Research Professor for Stony Brook University. He teaches AI and broadband policy. From 2002-2012 he taught digital economics and information systems management at New York University. He also taught in the Digital Media MBA at St. Edwards University in Austin, Texas, where he lives when not in Korea.

Comments

Comments are closed.

  • Categories

  • Referencing this Material

    Copyrights apply to all materials on this blog but fair use conditions allow limited use of ideas and quotations. Please cite the permalinks of the articles/posts.
    Citing a post in APA style would look like:
    Pennings, A. (2015, April 17). Diffusion and the Five Characteristics of Innovation Adoption. Retrieved from https://apennings.com/characteristics-of-digital-media/diffusion-and-the-five-characteristics-of-innovation-adoption/
    MLA style citation would look like: "Diffusion and the Five Characteristics of Innovation Adoption." Anthony J. Pennings, PhD. Web. 18 June 2015. The date would be the day you accessed the information. View the Writing Criteria link at the top of this page to link to an online APA reference manual.

  • About Me

    Professor (full) at State University of New York (SUNY) Korea since 2016. Research Professor for Stony Brook University. Moved to Austin, Texas in August 2012 to join the Digital Media Management program at St. Edwards University. Spent the previous decade on the faculty at New York University teaching and researching information systems, digital economics, and global political economy

    You can reach me at:

    anthony.pennings@gmail.com
    apennings70@gmail.com
    anthony.pennings@sunykorea.ac.kr

    Follow apennings on X

  • About me

  • Writings by Category

  • Flag Counter
  • Pages

  • Calendar

    November 2026
    M T W T F S S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
  • Disclaimer

    The opinions expressed here do not necessarily reflect the views of my employers, past or present. Articles are not meant as financial advice.

  • Verified by MonsterInsights